Tag Archives: administration

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

The Costs of Data

Posted on August 22, 2013 by way0utwest

Most of us know that there is a cost associated with the management and storage of data. After all, it’s part of the reason many of us have jobs as data professionals. Our salary is a cost, though we also … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on The Costs of Data

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