Tag Archives: sql server

The Human Cost of Managing Data

Posted on September 24, 2013 by way0utwest

If you’ve ever worked in a large environment, where the numbers of nodes number in the thousands, or tens of thousands, then you know many software packages don’t scale to that size very well. I’ve seen quite a few pieces … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Human Cost of Managing Data

The Dangers of Detach

Posted on September 18, 2013 by way0utwest

I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk. I agree that detaching databases in some cases is bad, but it’s not necessarily something I’d avoid. Detach is a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on The Dangers of Detach

Versions of Disaster

Posted on September 12, 2013 by way0utwest

Today’s editorial was originally released on Jan 13, 2009. It is being re-run as Steve is on vacation. I wrote about versioning of old software recently and how I had to restore an old version of SQL Server in response to a … Continue reading →

Posted in Editorial | Tagged , , , | 1 Comment

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