This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is a concept familiar with all developers and users of sensitive data. It is implemented in SQL Server with simplicity and elegance, requiring minimal changes to front end applications, including reporting, and almost no changes to queries. The series includes:
An in-depth introduction and use cases Setup, examples, testing recommendations, coding alternatives to Dynamic Data Masking Side-channel attacks Attack mitigations and general architectural-considerations
The dynamic data masking feature was introduced in SQL Server 2016. Data masking addresses gaps in exposing data to