New answers tagged


Downsides of Transparent Data Encryption compared to Always Encrypted: Only protects data at rest - backups and data files are "safe" but data in motion or in memory is vulnerable Whole database only Backup compression can take longer and be counter-productive tempdb also inherits encryption – stays even after disabling TDE Data always accessible to ...


Simply put, TDE is data encrypted at rest (On disk) and AE is data encrypted on the wire in addition.

Top 50 recent answers are included