Transparent Data Encryption in SQL Server 2008

SQL Server can now encrypt the entire database (both the data and the log files) automatically, and without requiring any programming or application changes on your part. This is achieved by using a new feature in SQL Server 2008, available only in the Enterprise edition, called Transparent Data Encryption (TDE). Data is encrypted on the fly as it is written to disk and decrypted when it is read back. Encryption is performed at the page level and does not increase the size of the database. Because the process is entirely transparent, it’s extremely easy to use TDE in SQL Server 2008. Let’s see how.

Note

The NTFS file system in Windows Server 2000 and later provides a feature called Encrypted File System ...

Get Programming Microsoft® SQL Server™ 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.