SQL Server 2005: searching encrypted data

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 we would also like to continue retrieving records based on its values, and…

19

About security and encryption with references to SQL Server 2005

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. The main point I want to make is that we cannot discuss security without defining what…

8

SQL Server 2005: Yet another column encryption demo – "Clinic"

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 Encryption Demo – “Clinic”—use master — Create two logins that will be…

5

A couple of links for submitting feedback on Microsoft products

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 are at: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1. The Product Feedback Center at: https://connect.microsoft.com/default.aspx. Update [2005/12/21]: Another useful link for reporting security vulnerabilities…

2

SQL Server 2005: The loginproperty builtin function

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 that specifies what information should be retrieved. The names of the properties are case insensitive,…

3