Last week, we had a heated discussion at work about encryption. We want to encrypt some data in our database, and I proposed that we go with a single private-key encryption mechanism (ignore which exact one for the moment), and my colleagues were pretty-much unanimously suggesting a ‘key per row’ approach. In this post I am going to attempt to explain the rough background, and why I felt their mechanism might not be best.
Archive for March, 2010
More Keys is More Secure. Right?
Saturday, March 27th, 2010Data Model Changes and Replication
Saturday, March 13th, 2010
Just a little reminder note today on the simplest way to make data-model changes in SQL Server 2005 when the database is replicated via transactional replication. This is from my own personal experience of replication and very-much muddling my way through learning how to use it effectively. Otherwise, this posts presumes you are familiar with Replication Monitor and so on.
Boolean Expressions
Friday, March 5th, 2010The C# code-base I work on has hundreds of places where I have felt a boolean expression could have been used to simplify the code substantially.