January 2008 - Posts

SQL Server 2005: How to debug errors in code that does encryption
Encryption builtin functions in SQL Server have no known issues and, if used properly, they will produce the expected results. However, if they are used incorrectly, it can be hard to figure out what exactly is the problem, so in this post I am going Read More...
Posted 31 January 08 12:36 by lcris | 0 Comments   
Filed under , ,
SQL Server 2005: A great post by Aaron Morton about using MARS to access opened keys
Aaron Morton has a very interesting post and demo that show how MARS can be used to access keys temporarily opened by a procedure. This is a must-read for anyone that is interested in implementing custom restrictions around the use of encryption keys. Read More...
Posted 17 January 08 10:20 by lcris | 0 Comments   
Filed under , ,
SQL Server 2005: Why you should not encrypt data with certificates
I often recommended to only encrypt data in SQL Server using symmetric keys and to reserve the use of asymmetric encryption for protection of symmetric keys and for signing. In this post, I will go in more detail about why asymmetric encryption is not Read More...
Posted 11 January 08 12:44 by lcris | 0 Comments   
Filed under , ,
SQL Server 2005: How to determine the size of a column that will hold encrypted data
This issue has been addressed before on forums, but with the heavy traffic, it can be hard to find the proper post. So, I'll provide some explanations here as well. Note: This article is written with symmetric encryption in mind, but the actual technique Read More...
Posted 11 January 08 11:05 by lcris | 0 Comments   
Filed under , ,

Search

This Blog

These posts are provided "AS IS" with no warranties, and confer no rights.

Syndication

Page view tracker