Tag Archives: encryption

Creating a Symmetric Key in SQL Server

Posted on April 25, 2012 by way0utwest

Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and resource usage, much better than asymmetric keys. Creating a symmetric key is fairly simple, using DDL that’s easy to understand. … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Key Storage

Posted on April 13, 2012 by way0utwest

One of the issues with encryption, perhaps the biggest issue, is the management of the keys that protect the encrypted data. I have been an advocate of keeping the backup of the keys far away from the backup of the … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Key Storage

Hashing Collisions

Posted on April 11, 2012 by way0utwest

One of the problems with hashing is that you can have collisions from values that are not very similar. This means that if you are using hashing as a way to identify similar values, you need to make further checks … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

The Encryption Primer

Posted on March 28, 2012 by way0utwest

This talk deals with SQL Server encryption options. I have given a few variations, and you can get the different decks below. SQL Server has a number of encryption features that allow you to better secure your data. This session … Continue reading →

Posted in Presentations | Tagged , , , | Comments Off on The Encryption Primer