SQL Server Encryption for the Layman

With GDPR and the number of data breaches we see in the news, encrypting sensitive data is becoming more and more important. In this session we will start by understanding the basics of encryption, before moving onto look at the ways we can encrypt data in SQL Server and Azure SQL DB. We will cover:

• Certificates, symmetric & asymmetric keys
• Encryption algorithms
• Encryption hierarchy
• Transparent Data Encryption (TDE)
• Always Encrypted
• Dynamic Data Masking (DDM)
• Encryption functions
• Stored procedure signing

Attendees should leave with an understanding of the options available to them, and which options are most suitable for different scenarios.