Dynamic Data Masking in SQL 2016

2015-07-23 10_51_06-sqlserver2016ctp2technicallevel300deck-150706223653-lva1-app6892.pptx - PowerPoiNew blog post on SQLShack this time i am walking through the new feature Dynamic Data Masking in SQL 2016

This feature enables you to mask data dynamically for your applications, and other data consumers, which should not be allowed to have full access to all data.

Here is a little excerpt from the article, if you would like to read it in full, please go to sqlshack.com

Dynamic Data Masking in SQL 2016

There are many new features in SQL Server 2016, but the one we will focus on in this post is:

  • Dynamic Data Masking

Have you ever been on a website, where your personal information, ie. Social Security number or Credit Card number shown in clear text, ready for everyone to have a look at. Would it not be cool if your information was somehow masked by default, and not needed to rely on the application to mask the data before displaying it on the screen?

Examples of Datamasking

Type Value Masked
Social Security number 320474-2345 320474-****
Credit Card 4566-6546-6546-7897 4566-****-****-****
Telephone +45 45454545 +45 45******
Email kenneth@mydomain.com K*******@*********.com

If you look at the above, then it is clear that it would be really nice to have your sensitive data somewhat masked when displayed on a monitor, that other people can look at the same time.

Now with the introduction of SQL Server 2016 we have the possibility to mask data in the database, and the data is masked when queried as well – this means that the application developers should not worry about this little security issue any more.

– See more at: http://www.sqlshack.com/new-features-in-sql-server-2016-dynamic-data-masking/

Leave a Reply