Mask Data in SQL Server - Dynamic and Static Masking

8/5/2016

We have recently enjoyed participating in the SQL Saturday Orange County with the seminar on Data Masking. While introducing new and exciting feature of Dynamic Data Masking, Microsoft has created some confusion in many people on when and how to use it. We have prepared a careful analysis of use cases and the demo for the data masking scenarios suitable for dynamic data masking as well as those that require static data masking in SQL Server. We would like to repeat this experience for those people who were not able to attend SQL Server Orange County and will be hosting the webinar in September.

The Agenda:

1. When do we need to mask data? Hierarchy of data access in the organization.

2. What is dynamic data masking and what is static data masking? Industry definitions.

3. Dynamic Data Masking: in SQL server 2016 and in Azure

a. Did you know you will need to alter schema?

b. Which data types does SQL Server 2016 cover? Use of generic and type-specific substitutions.