RetiredDBA.com

All things for Microsoft SQL Server

Ready for GDPR compliance solutions by May 2018?

Mar 15, 2018

GDPR compliance solutions by May 2018

On May 25, 2018, a European privacy law will set a new global bar for privacy rights, security, and compliance. The General Data Protection Regulation (GDPR) imposes new rules on organizations that offer goods and services to people in the European Union (EU), or that collect and analyze data tied to EU residents.

I hope you have been working on solutions at your organization, testing those solutions and are prepared to deploy those solutions. Right?

Even if your organization does not deal with any European Union (EU) people or data today, similar restrictions could happen in the US sooner rather than later. And if you need a jump start, try looking at this excellent article: GDPR – A guide for the perplexed by David Poole

Tons of GDPR related information posted on the Microsoft website for all of it’s products with many ideas and possible solutions.

Some of the SQL Server features to address GDPR are listed such as:

  • Azure SQL Database firewall limits access to individual databases.
  • SQL Server authentication helps you ensure that only authorized users with valid credentials can access your database server.
  • SQL Server authorization enables you to manage permissions according to the principle of least privilege.
  • Dynamic data masking (DDM) is a built-in capability that can be used to limit sensitive data exposure.
  • Row-level security (RLS) is an additional built-in capability that enables SQL Server to implement restrictions on data row access.

Reference Microsoft webpages: Discover GDPR compliance solutions