For my inaugural blog I would like to direct you to Jim Harris Obsessive-Compulsive Data Quality post on Data Profiling. He makes several important points regarding the techniques and methodologies in Data Profiling, and since I am not vendor neutral I would point out we provide all the capabilities Jim describes and more for SSIS.  Also I recently posted an article on Fuzzy Matching in TSQL on SQL Server.