Abstract

Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come 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
• Understand the code changes required for encryption mechanisms
• Gain a basic understanding of RLS and DDM, which do not require code changes to help protect data

Level: 100

Demos

This talk includes the following demos

• Always Encrypted setup and data access
• Row Level Security setup and use
• Dynamic Data Masking for users
• Column Level Encryption implementation
• TDE setup and verification