Tag Archives: administration

Job Worries over Automation

Posted on September 18, 2013 by way0utwest

There was a report recently where the NSA noted that they are reducing the number of system administrators by 90%. If the report is true, that would certainly worry many of the people in the technology industry. However I’m not sure … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Job Worries over Automation

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

Managing Data in a FileTable with T-SQL

Posted on September 11, 2013 by way0utwest

I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do you work with the data in this table? In this post I’ll look at a few things you can do … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Managing Data in a FileTable with T-SQL

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