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.


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.