I'd have to plead a partial on this one. I don't touch most major plumbing tasks, but have no worries messing with faucets, stems, toilets, basic PVC. I also don't...

Quick note - good solution to sending report-formatted data in SQL 2000. With the number of 2000 installs out there, this helps.

Agreed on using DB Mail to send HTML...

COALESCE is also ANSI compliant as well as handling something such as:

COALESCE(@var1, @var2, @var3, ..., @var#)

This will return the first non-NULL value in however many are passed in. Very...

I'm not so much hammering on the author (who did admit his mistake - several times), but it would be nice if we had a little better proofing of these...

Count me in for getting burned on this one. The question really needs to be clearer (as noted above). The example shown will only work with #2 and...

Definitely agree with this editorial. Taking the MS Certification tests is painful because it feels like we are spitting back BOL answers for a good portion of the entries....

I think the general concept behind GTD is pretty good. (Break your big tasks into small tasks and work through those until the big tasks are done.) Don't...

Maybe that's why we keep getting these QoDs - the poster inherited a system using this awful code. 😉

That being said, this is the second of these strange "out of...

Only problem I've noted with exporting to some form of delimited text and then trying to use SSIS is that Excel tries to save space when exporting. If you...

The UNION answer was the first one that popped into my mind as well. I'd never really thought of using the number of characters in the English name of...

Well, we used to restore all of our main databases nightly, but that hasn't been done in a while. Sadly, we sometimes need to restore one of our databases...

I completely agree with this. The system is just unwieldy. Enter a bug or feature request, see it closed with little/no explanation, eventually give up. I did...

Often being on the receiving end of bug reports, I'd agree about the cursing/foul language/personal attacks. It doesn't engender a desire on the programmer's part to fix the bugs...

First, I wanted to say that I think that you're dead on about us working all hours for our jobs. 🙂

As for the article that started this, I have...

Your gaming comment struck me. I had a couple of games that I owned legally for which the copy protection scheme was incredibly annoying. Reading codes printed in...