Tag Archives: encryption

Restoring a Certificate

Posted on March 5, 2012 by way0utwest

I have written about creating a certificate and backing up a certificate, and the next step is the restoration of a certificate into a server instance. This post covers the basics of restoring a certificate. There is no RESTORE CERTIFICATE … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Backing up a Certificate

Posted on February 27, 2012 by way0utwest

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately. Once you start to encrypt anything with a certificate, you increase the risk that you’ll lose your data if an … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Creating Your Own Certificates

Posted on February 16, 2012 by way0utwest

Did you know that you don’t need to go to Digicert or Thawte, or any other company to get a certificate to use in SQL Server? You can create your own certificate. Why you would want to do this is … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Encryption in Production

Posted on February 10, 2012 by way0utwest

The encryption capabilities of SQL Server have been growing in each new version. We have gone from password protected backups to Transparent Data Encryption (TDE), we have moved form PWDENCRYPT() to symmetric, asymmetric keys, and certificates. There are quite a … Continue reading →

Posted in Editorial | Tagged , | 1 Comment