THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

(YED) Young Engineers Disease

This blog has moved! You can find this content at the following new location:

Published Thursday, July 8, 2010 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Mike Decuir said:

It is nice to see this summarized so nicely.  It will make a great reminder of mistakes to avoid.  I already make many of these mistakes much less frequently than a year ago, but still more frequently than I am comfortable with, so the reminder will be very handy.

July 8, 2010 2:15 PM

andyleonard said:

Hi Mike,

  If you don't look at code you wrote six months ago and cringe, you're not growing.


July 8, 2010 2:51 PM

Mike Decuir said:

That is very encouraging.  Almost every bit of code I wrote 6 months ago makes me cringe.  Granted, the bits that don't make me cringe tend to be the parts like DECLARE statements.

July 8, 2010 6:58 PM

Chuck Rummel said:

I'd like to print that ("If you don't look at code you wrote six months ago and cringe, you're not growing.") in banner form for my desk, or make one of those motivational pictures (someone doing a facepalm maybe?) out of it.

There's some code I wrote that's stood the test of time (requirements haven't changed, and the code still performs the intended function well), some I cringe at because I know of better ways now (sometimes due to new version functionality) but haven't had a chance to implement, and some I still cringe at thinking there still has to be a better way and still searching for it.

July 8, 2010 10:04 PM

AjarnMark said:

Great post, Andy!  I can't tell you how many times I have seen symptoms of Sunny-Day Design!  Especially the "click buttons in a prescribed order".  The parallel to that is "enter data in the fields in a prescribed order" too.  How many times have you seen someone trapped in an infinite loop because they entered wrong dates and the validation routine keeps kicking them out of the place where they need to fix it, telling them that they have invalid dates.

I 100% believe in Christy's quote, but as much as possible, I try to gain good judgment from learning from OTHER peoples' experience and bad judgments.  It's less painful that way.  But believe me, I have plenty of my own scars that I have picked up along the way.

July 13, 2010 6:03 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement