In this session, we will discuss three SQL Server features that provide security for your data. Starting with Row-Level Security and how it is used to provide access control to ranges of records in a table. Next, we focus on Dynamic Data Masking and how it is used to hide sensitive data in the result set of queries. Finally, how the Always Encrypted feature is used to provide encryption for sensitive data in transit.


John has been a Microsoft Certified Trainer (MCT) since July 2000 and specializes in teaching Azure SQL and SQL Server workshops. He is currently a Data and AI Cloud Solutions Architect for Microsoft, an MCT Regional Lead for the Eastern United States, and a former Data Platform MVP.