Under the Hood of Transparent Data Encryption: Securing Data at Rest in Azure SQL and SQL Server

Regular 50 minute session for SQLBits 2026Wednesday - 22 Apr 2026 - 16:40 - 17:30 Room 3A

TL; DR

Flip the switch on TDE! Join our deep dive into how Transparent Data Encryption works in Azure SQL & SQL Server. Learn architecture, performance tips, and CMK integration—plus demos and practical guidance for DBAs and security pros.

Session Details

Ever wondered what really happens when you flip the switch on Transparent Data Encryption (TDE)? Join us for a technical deep dive into how TDE works in Azure SQL and SQL Server.
We’ll unpack the architecture behind TDE, explore how it protects your data at rest. You’ll learn how to measure and mitigate performance impact, and integrate TDE with customer-managed keys (CMK) for maximum control and compliance.
Expect demos, architecture diagrams, and practical tips you can take back to your team. Perfect for DBAs and security architects who want to go beyond the basics

3 things you'll get out of this session

Demystify how TDE works under the hood in Azure SQL and SQL Server
Equip attendees to measure and optimize performance
Show how to extend TDE with Customer‑Managed Keys (CMK)