Niall has been building data solutions on the Microsoft platform for 12 years. In the past few years Niall has been focused on helping clients with data engineering in Azure. Niall is active in the data community, helping run the Bristol user group.
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