SQL Server 2005: using symmetric keys to encrypt data

In SQL Server 2005, the recommended method for encrypting data is to use symmetric keys. In this post, I’d like to comment on three topics related to using symmetric keys: 1) basics of using a symmetric key2) ways to restrict access to a symmetric key3) how to prevent a symmetric key loss So, let’s tackle each of these: 1) Basics of using a symmetric key A…


A new blog link

Here’s a link to a new blog that a colleague has started: http://blogs.msdn.com/yukondoit/. The first entry is about the various levels of data protection in SQL Server 2005 and you can access it at: http://blogs.msdn.com/yukondoit/articles/480854.aspx.


Converting SQL Server 2005 certificates to PFX format

I just found a very nice article on Kyle Alons’s blog, about how to convert a certificate from the cer/pvk format to the pfx format: http://www.kinook.com/blog/?p=10