O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required