New 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
|Social Security number||320474-2345||320474-****|
|Telephone||+45 45454545||+45 45******|
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.