The Basics of Dynamic Data Masking - Step 1 of the Stairway to Dynamic Data Masking

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.

Default Data Masking

Exploring SQL Server 2016 Dynamic Data Masking – Part One

Greg Larson looks at how to hide the value of sensitive data by applying Dynamic Data Masking.

SQL Server 2016: The Data Protection Version

Today Steve Jones looks at the security enhancements in SQL Server 2016

Data Masking for Convenience

Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.

Understand the Limitations of SQL Server Dynamic Data Masking

Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.

Learning Dynamic Data Masking

Information and links about Dynamic Data Masking in SQL Server 2016

Use Dynamic Data Masking in SQL Server 2016 CTP 2.1

SQL Server 2016 introduces a new security feature called Dynamic Data Masking (DDM). This tip describes its purpose, shows a brief example of how it works, lists some limitations, and notes how the feature has already changed since CTP 2.0 was first released in May.

RE: Friday the 13th

Hey Steve! Kids are great aren't they.  I have to forewarn you though, "And more reasonable." probably won't last forever.  Just like most things in this wonderful world, I have found my children's reasonability is cyclical.  When very young, you certainly can not reason with them, but they slowly rise on the curve of reasonability.  It has been my […]

RE: SQL Server 2000 SP4

This is found in SQL Server Books on-line. Initially we had 4 GB (3 GB for SQL + 1 GB for OS) with AWE Option disabled. Once we upgraded from 12 GB (10 GB for SQL + 2 GB for OS) we enabled AWE. It makes sense to enable AWE if we have more than […]