The Azure Security Podcast cover image

The Azure Security Podcast

Episode 87: Advances in Always Encrypted and Transparent Data Encryption

Nov 15, 2023
Michael's colleagues Pieter Vanhove and Mirek Sztajno discuss updates to Always Encrypted and Transparent Data Encryption in SQL Server and Azure SQL DB. They explore key rotation, database-level key specification, advancements in database encryption, secure enclaves in Azure SQL databases, and compare TDE with Always Encrypted for data security.
21:07

Podcast summary created with Snipd AI

Quick takeaways

  • Transparent Data Encryption (TDE) now supports AKV for managing keys, offering improved security and key rotation.
  • Always Encrypted with secure enclaves enables enhanced query functionalities and in-place encryption, providing flexible data protection options.

Deep dives

Transparent Data Encryption (TDE) Innovations

The transparent data encryption (TDE) team introduced new features focused on customer-managed keys and enhanced protection. Customers can now use AKV (Azure Key Vault) to manage keys, granting ownership and control. TDE secures databases, transaction logs, and tempDB, with options for system-managed or customer-managed keys. The update includes key rotation, allowing for increased security by periodically changing key versions.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode