Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. Master the concepts of SQL Server Encryption when you are done with this session.

Ben is a SQL Server Certified Master, MVP, author, speaker and mentor. He is a passionate member of the SQL Server Community for 15+ years. Ben has worked in the field using SQL Server since 1997. He mainly works in the Enterprise DBA areas, including Clustering, Availability Groups and other forms of HA as well as SQL Server configuration and infrastructure setup. He is an advocate for using PowerShell for DBAs and blogs and speaks regularly on these subjects. He worked at Microsoft for 7 years in the SQL Server Support and MVP Lead roles. He is passionate about SQL Server, automation and integration.