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


Advertisement

Ally - Get a bonus when you open an eligible Ally Bank account.

Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa

Chase Checking - Open your Chase checking account and get a bonus!

Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.

Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.

Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!

Discover - Get a bonus when you open an eligible Discover account.

Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!

Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.

Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.

Xfinity - Open an Xfnity mobile or internet account and get a bonus