PART II – Data security enhancements in SQL Server 2005

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 in case of user mistake or corruption.   For this, we need to protect our…


PART I – Data security enhancements in SQL Server 2005

In this two part series, we will talk about data encryption and its implementation in SQL Server 2005.   You may encrypt sensitive data like credit card numbers, client information etc. using SQL Server data encryption functionality.   Let’s take an example to demonstrate the different steps involved in encrypting and decrypting your data.  …