SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily SQL Server 2008 New Feature – Day 7

 Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Friday 14th May 2010

Transparent Data Encryption

Enable encryption of an entire database, data files, or log files, without the need for application changes. Benefits of this include: Search encrypted data using both range and fuzzy searches, search secure data from unauthorized users, and data encryption without any required changes in existing applications.

Is SQL Server finally becoming as secure as its Oracle equivalent? Thats a debate in itself !


Posted by Steve Jones on 14 May 2010

This is a great feature, unfortunately, it's an Enterprise only feature, when it would be useful in every versions


Be aware that this does reduce, or eliminate gains with backup compression. Not sure about data compression.

Posted by Justin Hostettler-Davies on 20 May 2010

Ah yes - maybe one day our friends at Microsoft will have a radical change of thought and allow us access to all these new features in ALL versions ! - Then again isn't there more chance of England winning the World Cup this year?

Leave a Comment

Please register or log in to leave a comment.