features sql server 2016 versus sql server 2016 express

post should have given you a basic understanding of the concept of Dynamic Data Masking, and should enable you to use it on your own data/tables when you make the shift to SQL Server 2016.

SocialSecurityNumber is masked to show only the first 6 digits and masking the last 4 digit.

Birthplace is masked to show only first letter and all remaining letters is replaces by X.

Phonenumber is masked to only show country code and last number in this number format.

Email is masked by function Email and therefore only showing first letter and top-level domain.

Birthdate is masked to be for all records.

Lastname is masked by default, leaving all traces of a name masked and replaced by 4 X.

Firstname is masked so that the first letter is visible and all remaining letters is replaced by X.

and you will see that the data is masked as by the function we defined earlier. In the query window, you can now issue statements where you select data from the table. Now we are ready to query the data that we have put a dynamic datamask on. Type in the password “DynamicMask” in password

Type in the name “DynamicMaskReader” in login.

When this user is created, you have to open a new Query and connect to the database using the new user. While it is a feature in CTP 2.1 and enabled by default in this build, you should enable a few trace flags to use it, of you are using CTP 2.0 build. 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.

+45 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. 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? Social Security number or Credit Card number shown in clear text, ready for everyone to have a look at. Have you ever been on a website, where your personal information, ie. There are many new features in SQL Server 2016, but the one we will focus on in this post is:

Features sql server 2016 versus sql server 2016 express