Day: July 11, 2011

In a previous post, I displayed one method to encrypt data. This post is to show how to show the decrypted data. This post refers to the objects used/created in the previous post. Continue reading SQL Server Decryption

Recently I had to show that data can be encrypted in SQL Server 2008 database. The purpose was to not store the raw value in a table where anyone with access could see the sensitive data. The original process truncated the destination table and then populated the destination table with data pulled from the source table. Seeing that as an issue, I made a change to the process in addition to adding encryption. Continue reading SQL Server Encryption