SQL Server in the Cloud

SQT05 Implementing Data Protection and Security in SQL Server 2016


11:00am - 12:15pm

Level: Intermediate

Steve Jones

Data Platform MVP, MCSE, BA



The data protection and security features in SQL Server 2016 and Azure SQL Database provide for a much broader level of data security. Microsoft has simplified many of these features to reduce the burden on the developer. This session will examine how the new Always Encrypted feature protects communications between client and server, and how developers can easily set this up. This session will also examine how Dynamic Data Masking and Row Level Security protect data from unauthorized access, eliminating the need for front-end developers to handle these functions.

You will learn:

  • How Always Encrypted works and how to implement this both on the server and client sides
  • How Dynamic Data Masking can be used to prevent sensitive data from being returned to client applications and what client applications can expect to receive
  • How Row Level Security automatically limits data from being returned to the client, which allows front end developers to focus on their business logic without worrying about security of individual rows