SQLBits 2019

SQL Server Encryption for the Layman

With GDPR and the number of data breaches we see in the news, encrypting sensitive data is incredibly important. In this talk we start with the basics of encryption, moving on to look at the ways we can encrypt data in SQL Server and Azure SQL DB.
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.