Caveman's Blog

My commitment to learning.

SQL Server – Transparent Data Encryption – TDE

with one comment

Transparent data encryption (TDE) is a new feature in SQL Server 2008 that can be used to encrypt the storage of an entire database. TDE encrypts the data using a symmetric key called the database encryption key.

Protect the database encryption key by using an asymmetric key stored in an extensible key management (EKM) module. EKM provider needs to be contacted to get a HSM device.  According to Microsoft, implementation of TDE does not have any impact on the through-put to the database in the SQL Server 2008.


1. MSDN Online.


Written by cavemansblog

October 6, 2010 at 10:12 am

Posted in Sql Server

Tagged with , ,

One Response

Subscribe to comments with RSS.

  1. I hope it is ok that I point out that there are other options for SQL Server Encryption. For example, NetLib Encryptionizer ( provides TDE in SQL 2000 through 2008, Express through Enterprise.

    Neil Weicher

    September 30, 2011 at 9:28 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: