December 2005 - Posts

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 Read More...
Posted 22 December 05 02:19 by lcris | 19 Comments   
Filed under , , ,
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. Read More...
Posted 20 December 05 02:06 by lcris | 8 Comments   
Filed under , , , ,
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 Read More...
Posted 16 December 05 08:50 by lcris | 5 Comments   
Filed under , , ,
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 Read More...
Posted 01 December 05 02:32 by lcris | 2 Comments   
Filed under ,
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 Read More...
Posted 01 December 05 12:00 by lcris | 3 Comments   
Filed under , ,

Search

This Blog

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

Syndication

Page view tracker