SQL Server 2008: Transparent data encryption feature
TDE addresses two of the encryption requests:
(1) a way to enable data encryption without affecting applications that consumed that data (for an idea of what problems are raised when encrypting a table column in a database, see this post).
(2) a way to encrypt an entire database.
TDE addresses both these requests by providing a database level encryption feature. Both the data and the log files of a database are encrypted on disk and get decrypted when they are read into memory. This makes encryption really transparent to applications.
At Laurentiu Cristofor's blog.
[ Read more ]