One of the cool feature of SQL Server 2005 is out of the box data encryption capability. Not like SQL Server 2000 that requires 3rd party support or creating your own custom script, SQL05 comes with built in function to do that.
It supports both symmetric and asymmetric encryption, as well as hashing. I created a sample script to do symmetric encryption. A slide deck presentation also available for a quick review about encryption architecture.
Actually I created this material for one day SQL Server security workshop at Avantus. This one day workshop covers encryption, SQL injection, SQL Lock down, and security administration. I decide to release the encryption module here along with the sample script, but not include the detail manual. Some of the material comes from Lara Rubbelke’s presentation.
For some of you that still stick on SQL 2000, Michael Coles already created an encryption toolkit with no cost.
Download the presentation.
Download the sample script.
October 11th, 2007
I just received an email from Microsoft 3 days ago, stated that I’m awarded as an MVP again. This is my 3rd year renewal, thanks!
Dear Muhammad Amri,
Congratulations! We are pleased to present you with the 2008 Microsoft® MVP Award! The MVP Award is our way of saying thank you for promoting the spirit of community and enhancing people’s lives and the industry’s success every day. Your extraordinary efforts in Visual Developer - ASP/ASP.NET technical communities during the past year are greatly appreciated.
There are several notes for this year renewal:
- I’m awarded as a Singapore MVP, and no longer Indonesian MVP. Since I moved to here for my job, my MVP lead transferred my award status to Singapore.
- Despite my award that belong to Singapore region, I’m still going to continue my activities for Indonesian communities such as IlmuKomputer.Com and SQL Server Indo. I’m still on my commitment to do writing and participating in online forum.
- I did several writings for SQLServerCentral last year, and I want to increase it next year. I will participate more on global online portal and Singapore communities.
Hopefully I can do better next year 
October 5th, 2007
