Finally, after rounds of CTPs (Community Technology Previews) and great feedback from customers, we have officially released Service Pack 2 (SP2) for SQL 2005. Download SP2 You can download it by visiting the Microsoft website here . Enhancements...

In the previous edition ( Data security enhancements in SQL Server 2005) , we talked about data encryption/decryption in general. In this installment, let’s talk about key maintenance. It is important to ensure that we can decrypt our data, even...

The other day I was working on an issue with one of our customers. I had been having him run several different tests using a few of the tools that we use on the SQL Developer team on a daily basis. After about the third or fourth diagnostic we ran...