September 2005 - Posts

SQL Server 2005: A look at the master keys - part 2
This is a continuation of a previous post , in which I discussed the service master key (SMK) and the database master keys. I mentioned in that post that a new encryption will be added to the SMK and I will describe it in this article. Also, a few things Read More...
Posted 30 September 05 10:51 by lcris | 14 Comments   
Filed under , , ,
SQL Server 2005: How to fix outdated names of Windows logins
The SQL Server login catalogs store the names of Windows principals as well as their SIDs. Because the names are stored, changes that affect a name can lead to a state where a catalog entry is out of sync with the current login name. For example, in the Read More...
Posted 27 September 05 10:34 by lcris | 0 Comments   
Filed under ,
SQL Server 2005: An example of writing a CLR function that wraps the LookupAccountSid WinAPI call
I was looking recently into writing a wrapper for the LookupAccountSid WinAPI function, so that I could use this functionality in T-SQL. I decided to write a CLR function and document the steps here: 1. First, we need to write the code into a file - I Read More...
Posted 26 September 05 03:51 by lcris | 1 Comments   
Filed under ,
SQL Server 2005: Comments about cryptographic keys and their encryptions
I want to collect here some basic facts about the encryptions of the various cryptographic keys in SQL Server 2005: - a database master key (DbMK) must always have at least one password encryption, but it can have more than one. Also, by default, the Read More...
Posted 23 September 05 04:42 by lcris | 0 Comments   
Filed under , , ,
An example for setting database mirroring in SQL Server 2005
I am not a database mirroring expert, but a while ago I have set up database mirroring between two of my machines. I collected the steps that I followed in the following script: -- This script illustrates how to setup database mirroring between two machines. Read More...
Posted 14 September 05 10:45 by lcris | 2 Comments   
Filed under ,

Search

This Blog

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

Syndication

Page view tracker