Tag Archives: encryption

Encryption and Full Text Search at The Mandalay Bay (DevConnections)

Posted on September 23, 2013 by way0utwest

It’s just a week until Dev Connections.  This is one of the great conferences for the hybrid technology person, with a variety of technologies being talked about, all for a single admission price. I’ll be speaking at SQL Server Connections, … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on Encryption and Full Text Search at The Mandalay Bay (DevConnections)

Backups, Encryption and Branding in San Diego

Posted on September 16, 2013 by way0utwest

This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but mostly because I used to live in the Northern San Diego area and love going back to spend time near … Continue reading →

Posted in Blog | Tagged , , , , , , | 3 Comments

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

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