Yesterday I had the pleasure of recording another new podcast on a SQL Server 2019 topic. Jakub Szymaszek is a PM on the SQL Server team, working around security.
In this podcast, Jakub and I discussed the current state of security and encryption in SQL Server, starting from cell-level encryption (CLE) and transparent database encryption (TDE) in SQL Server 2005. We then discussed the introduction of Always Encrypted and Data Masking in SQL Server 2016.
Finally, we spent time discussing the enhancements in SQL Server 2019 and the related tooling, particularly focusing on Always Encrypted with Secure Enclaves. We look at the scenarios it now enables, and what's required to support it, including a host attestation service.
Hope you enjoy it.
Warning: there might be some brain explosion material here for some 🙂
You'll find more details here: