A major trade-off is that the TempDB is also encrypted even if only one database has TDE switched on. This has performance implications. Because the application does not have to change, this is ideal ...

Data encryption performs two purposes: it protects data against internal prying eyes, and it protects data against external threats (hacking, theft of backup tapes, etc.) Encryption in the database ...

I was looking a Red-Gate's SQL Backup program and was rather interested in the encryption options that the PRO version offered. It claims up to 256 bit encryption, but I was wondering how "secure" ...