I just discovered CodeSmith.  Regardless of the what type of development you do -- be it C#, VB.NET, ASP.NET, WinForms, SQL, ASP or even VB4, for crying out loud -- you must have this tool.

Some of you might ask, “Where have you been?!  I've been using this tool for [some_unbelievably_long_period_of_time]!!!”  Sure, I heard about it a long time ago.  I guess I was just “too busy” to see what it was really all about. 

WHY, OH WHY DIDN'T I DOWNLOAD CODESMITH SOONER?????

I never much cared for code generation tools.  Usually you have to conform to someone else's idea of what a stored procedure, data class, business class, etc. should look like.  CodeSmith is so much more than a code generation tool.  If you can create a template for it, this sucker will crank it out.  I can see now how I could automatically generate 90% of my stored procedures, data and business access layers, exactly the way I want.

I'm sitting here kicking myself, HARD, thinking about all the hours and hours of mind-numbing cut & paste / search & replace I could have saved myself over the last year using this tool.  Oh, well... at least most of it was billable hours...