Career Limiting Move, SQL Server 2008 Transparent Data Encryption

re: Career Limiting Move, SQL Server 2008 Transparent Data Encryption

Buck Woody - Microsoft — Wed, 27 Aug 2008 06:48:05 GMT

Ah - but this DBA is career limited not because of the feature, but because he/she refused to read the documentation. Even in the overview topic for this feature it says, and I quote:

"Note:

When enabling TDE, you should immediately back up the certificate and the private key associated with the certificate. If the certificate ever becomes unavailable or if you must restore or attach the database on another server, you must have backups of both the certificate and the private key or you will not be able to open the database. The encrypting certificate or asymmetric should be retained even if TDE is no longer enabled on the database. Even though the database is not encrypted, the database encryption key may be retained in the database and may need to be accessed for some operations."

re: Career Limiting Move, SQL Server 2008 Transparent Data Encryption

Thomas Tomiczek — Wed, 27 Aug 2008 15:53:25 GMT

Like real DBA's read documentation ;)

You are right, though. I had a friend that did exactly that move with his data partition and Vista - disc encryption, no key backup. Private only, so noone fired him. He called me with exactly that question... and I basicalyl told him to keep the hard disc - as a permanent remainder for all the data he lost access to.

re: Career Limiting Move, SQL Server 2008 Transparent Data Encryption

Steve Austin — Wed, 17 Sep 2008 21:42:27 GMT

"real" DBAs also test new features before exposing them to the business, regardless of what the docufiction says. ;)

MOSS 2007 and SQL Server 2008 - Better Together

Vantage Point - Bob German's WebLog — Wed, 08 Apr 2009 20:21:07 GMT

H1 { FONT-SIZE: medium } Many thanks to everyone who attended the MOSS 2007 and SQL 2008 "Better Together"

Office SharePoint Server 2007 and SQL Server 2008 - Better Together!

Microsoft Technology Centers blog — Thu, 16 Apr 2009 04:23:12 GMT

(Cross-posted from Vantage Point: Bob German's Weblog ) H1 { FONT-SIZE: medium } Recently Rich Crane