How to search encrypted data is a question that came up several times on forums and I should have blogged about this issue earlier, but better later than never. So the problem is that we have just encrypted that confidential column in our table, but...

There have been many books written on security and encryption, and there is much talk about security these days. I will not bring anything new with this post to the general topic of security, but I would like to present some ideas in condensed format...

Here's another demo I just used for a presentation of SQL Server 2005 encryption features. This shows how multiple keys can be used for encrypting data in a column and also how access to keys can be controlled. It's a fairly long demo: -- -- Column...

I want to advertise a couple of sites that can be used for submitting feedback and suggestions, or for filing bug reports for Microsoft products. These are: The Microsoft Technical Forums at: http://forums.microsoft.com/MSDN/ . The SQL Server Forums...

In this post, I'd like to describe a builtin function that is very useful for login management: loginproperty . Loginproperty accepts two arguments: the first is the name of the login for which information is requested and the second is a property name...