Transparent Data Encryption in SQL Server 2008

In this video Brian covers the new Transparent Data Encryption feature in SQL Server 2008. Transparent Data Encryption encrypts the data files to prevent someone from copying the data files and using them on another server without being decrypted first.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

Kevin Cole on 1/28/2009

Presentation is well-structured. The only aspect that may deserve mention is that the presenter spoke just a bit too quickly. Thanks!

Daniel Wolford on 1/28/2009

Would have liked to see a couple of examples of time to return 100,000 + rows before and after encryption. Very useful video to see how easy it is to set up TDE. Thanks

Carla Wilson on 1/28/2009

Excellent! Very well explained. Thank you.

27C2C5BC29 on 1/28/2009

didnt play

5161F3462C on 1/29/2009

Thank You

Prasanna Prabhu on 5/1/2009

1. Can we have multiple Master Key? If "YES" how can we specify which one to use, in your "CREATE CERTIFICATE" SQL statement 2. Can we have multiple DB Encryption Key? If "YES" how can we specify which one to use, in your "CREATE DATABASE ENCRYPTION KEY" SQL statement 3. I wish the DEMO had also shown how to consume those keys, just to make sure what we created, really worked. May be there is another video that you have coming :)

Raju on 8/5/2009

It will be good to have more information about cell level encryption too.

Crystal on 1/23/2010

Thank you for this step-by-step tutorial; It was a HUGE help!

Manish on 5/16/2010

very nicely explained

kam on 5/26/2010

Great

Anil Babu on 7/30/2010

its good

Rob Ralston on 7/5/2011

Good topic. An explanation of how to recover to another SQL Server if necessary would be helpful.

Carlos B. Vasquez on 7/5/2011

No need to read books online with this video for TDE.

Bob McLeod on 7/5/2011

Very good overview of TDE. Thanks.

revanth on 7/5/2011

its not clear, it would be good if explained properly

MInxia on 7/5/2011

clear and usefull

John Couch on 7/5/2011

I would like to have seen a disaster recovery scenario using TDE. I setup TDE once before , but was always concerned about restoring from a disaster.

Elmozamil on 7/6/2011

It is a good video and really learn something today, you can start your work by viewing such videos. Thanks a lot. Elmozamil Elamir

Steve Powell on 7/6/2011

Some info about rstoring a cert key might have been usfeul. Also watching the percent complete progress increase might have been useful when the encryption was running

aaron williams on 7/6/2011

excellent

kishore76 on 7/6/2011

Where can i download the script that you used in your demo.

Eric Willesmtein on 7/8/2011

Simple but very good explanation of setting encryption

ravi on 7/13/2011

worthy Article

Anbuchelian on 7/19/2011

I like this demo. The instructor was bit fast in talking. He can slowdown a bit.

ravi on 7/19/2011

worthy article

Maurice Ivory on 11/21/2011

This video was very interesting....I enjoyed it.