Tag Archives: sql server

Backup Your Certificate for TDE

Posted on August 26, 2013 by way0utwest

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one. If you didn’t make a backup, or you … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Backup Your Certificate for TDE

Guidance

Posted on August 20, 2013 by way0utwest

How do you manage SQL Server? Do you have a list of rules that tell you to do yy whenever xx happens? Or if yy doesn’t solve the problem, you next try zz? Some of you have guidelines like that, … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Guidance

Restoring a TDE Database on a New Instance

Posted on August 19, 2013 by way0utwest

You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get this database working on a new instance? This short post will show you how this works. Files Needed There are … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Restoring a TDE Database on a New Instance

Patch Problems

Posted on August 13, 2013 by way0utwest

I ran across this article a week or so ago, but hadn’t had a chance to put anything out. There were three patches put out in July for various products that caused issues with other software, one of which was SQL Server.  can … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Patch Problems