Tag Archives: security

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

Anonymous Research

Posted on February 13, 2012 by way0utwest

It’s no secret that anonomizing data doesn’t always work well. We have heard about this when Netflix released their data for people to build algorithms with. Some people were identified based on the data released being correlated with other data the people had entered on the … Continue reading →

Posted in Editorial | Tagged | Comments Off on Anonymous Research

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