As I write this I am still awaiting the official release of SQL Server 2016 so that we can explore the usefulness of its "Always Encrypted" feature.
I would just like to know what the specific differences will be between Always Encrypted & the currently available Transparent Data Encryption in SQL Server 2016 so that we can make the correct decision for future projects.
Best Answer
Downsides of Transparent Data Encryption compared to Always Encrypted:
Backup compression can take longer and be counter-productive
tempdb also inherits encryption – stays even after disabling TDEAlways Encrypted addresses all of these issues in part or in full:
There is a limitation, though, and that is that not all drivers and applications can deal with the encrypted data directly, so in some cases this will require updating/changing drivers and/or modifying code.