Database and Analytics

TH07 A Tour of SQL Server 2016 Security Features

05/18/2017

9:30am - 10:45am

Level: Introductory to Intermediate

Steve Jones

Data Platform MVP, MCSE, BA

Editor

SQLServerCentral

Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that help make data protection and security easier for developers and DBAs with a framework for protecting data. This session will help you learn how Always Encrypted, TDE, Row Level Security, Dynamic Data Masking, and column level encryption can protect your systems.

You will learn:

  • About the different encryption and security features in SQL Server
  • The code changes required for encryption mechanisms
  • About RLS and DDM, which do not require code changes to help protect data