Most of the solutions I see here have flaws, in that they do not handle one or more of these scenarios: (1) it is a leap year, (2) the DOB...

I have to agree with most of Old Hand's suggestions. Here are a few other practical ideas:

(1) ISBN, title, and author should be not null (title should be longer than...

I work with a female programmer who is married...she thinks of herself as having many traits more commonly found in men, such as an obsession with computer games, etc. But...

I confess that I find the note by Lutz Albers much more comprehensible than the article about outer joins itself. I have found that doing everything inside of a stored...

Excuse my ignorance, but what are those CHAR(10) things doing? How does that work? Please explain.

Thanks for reminding me of this trick that, as a DBA, I've known about for several years. What I REALLY want to know is the tricks for SQL Server 2005!...

This article was laugh-out-loud funny! It's amazing what some nervous, nerdy DBAs will come up with when their minds go blank during an interview. Of course, it's not funny either,...

I used to work at Spyglass, where the Mosaic web browser was invented (and ultimately sold to Microsoft). A few points: 1) HTML is, indeed, a specific instance of XML....