SQL 2008 - Encryption - No more app changes!!

If you have used SQL 2005 encryption before, you might have hated the fact that you need to rewrite you application to access encrypted data. You had to use the encryptbykey and decryptbykey functions to write and read encrypted data. Well, the good news is in SQL 2008, we will do transparent data encryption which means once you encrypt your database, your application need not worry about using special functions to write and read encrypted data.