Transparent Database Encryption With SQL Server 2008

Published: 1/27/2010 | Updated: 1/27/2010 | Discuss

As I was beating my head against the wall with SQL Server encryption, I was envisioning horror scenarios of converting my columns to varbinary, calling ENCRYPTBYKEY all over the place and doing other unspeakable atrocities to my database, I was happy to learn about Transparent Data Encryption (TDE) introduced in SQL Server 2008.

TDE makes database encryption transparent, so you don’t have to change the schema. It also addresses the issue of protecting data “at rest” which is critically important to some companies.

I found two good MSDN resources on the subject:

Hope this helps! (Seriously, ScottGu needs to copyright this line).

Comments

1 Nick Berardi | Wednesday, January 27, 2010 at 10:12 AM

Wouldn't that be a trademark and not a copyright. :)

2 Milan Negovan | Wednesday, January 27, 2010 at 11:33 AM

Well, whatever Paris Hilton did. :)

Emails and Notifications

Would you like to be notified when somebody responds to this post? Would you like to have these comments emailed to you?

Submit your comment

Please enter only text since all HTML tags except hyperlinks will be stripped. Hyperlinks will become live links. Any comments with flaming or offensive language will be deleted. Be courteous to other posters. Thank you.

Your name (required):

Your email (optional):

Your site's URL (optional):

Type in the number above:

Comment (required):

Remember me

This work is licensed under a BSD license.

Validate page XHTML for compliancy with web standards

Validate CSS for compliancy with web standards