We recently posted a blog about SQL 2005 Security enhancements, focussing on encryption and decryption.

Check it out and let us know what you think.

http://blogs.msdn.com/sqlblog/archive/2006/11/02/part-i-data-security-enhancements-in-sql-server-2005.aspx