GDPR Requirement and Microsoft SQL Server

GDPR Requirement and Microsort SQL ServerIn the month of May 2018 all the countries that are part of European Union will be implementing a new law – General Data Protecting Regulation aka GDPR. In this post, let us talk about GDPR in general and how GDPR requirement and Microsoft SQL Server can go hand-in-hand. GDPR is basically a data protection law, a compliance that is must to be adhere too by each and everyone. Just for the sake of the information, your organization is in scope of GDPR in case your organization is based in EU or manages data of any EU citizen.


According to the definition, according to SunGard GDPR is:

  1. The right to private life as a universal human right and
  2. The right to have one’s personal data safeguarded as a distinct, standalone universal human righ

GDPR Requirement and Microsoft SQL Server:

Microsoft SQL Server is one of the best database management system that offers in-built security mechanism that can help your ensure that all your data are compliance with the GDPR. Security and Microsoft SQL Server goes hand-in-hand because of the security features that Microsoft SQL Server provides, the only thing is, that one must implement it.

Well, for every organization or institute or company or government has there data that is vital to them, and not to be accessed by the authorized person or entity only. And that is vital to set some security standards for such a critical data so that you can prevent your data as much as you can with proper security mechanism and set of standards within organization and in your scope for MS SQL Server Security.

Above, is an excerpt on Security from my old blog space where I have pen down some of the important key areas that we can tighten the security, and here in another article on my old blog space I talked about how we can use SQL Server Risk Register, the PMP way to keep track on how one is doing with security implementation and how one can assess it.

There many built-in features like below to tighten the security and keep compliance with policies:

  • Login Audit
  • Encryption
  • Server and Database Roles
  • Row level Security
  • Policy basedManagement
  • Ownership and User-Schema separation

Here are some more troubleshooting tips and few posts on Security in case you would like to read more.

photo credit: rogiro Trust via photopin (license)

Leave a Reply

Your email address will not be published. Required fields are marked *

Hemantgiri Goswami

Hemantgiri Goswami

Hemantgiri is a seasoned SQL Server Consultant with demonstrated history for close to 21 years. He is a published author specializing in High Availability and Disaster Recovery area. He was awarded Most Valuable Professional by Microsoft 4 times. He is a regular speaker at events in Surat. Hemantgiri is founder and leader of the SQLPASS Chapter for Surat.