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...

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...

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 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...

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...