A lot of people have asked what goes into the making of a SQL Sam story. (Well, actually, only my wife has. And, after I started explaining it to her, her eyes glazed over and she suddenly found something else to do. But let's pretend that somebody might want to know...)Each story is based on something that really happened to me. I make a note of it, write down the details so I can reproduce it later on, and save it for one of the rare times when I have time to write the story. Each story takes about six hours to write. (Most of that is trying to think of plot elements: technical things like a beginning, middle, and end.) As I write the story, I try to make up names that convey the mood I'm in. Usually the names of people, the expressions they use, or even the names of machines used to illustrate the problem come from some bit of popular culture. If you're hip (translation: if you grew up in the sixties and seventies, or watch a lot of television), you might spy some of the "jokes". Here's a key to the ones that I consciously know about:
SQL Sam and the Evil Twin
SQL Sam and the Too-Slow Query
SQL Sam and the Phantom Connection
- The game show refers to "Let's make a Deal", where people could pick a prize hiding behind a door.
- SQL Sam asks what's behind the door marked NULL. "Who know's?" replies the host. This refers to the use of three-value logic in a database. The crowd screams "Not NULL!"; try to figure out what NOT Null means sometime and you'll wish you'd never heard of NULL.
- The name of the junior DBA, Jimmy Jerry, actually has two references. The first is to the old Superman show, with Jimmy Olsen, the cub reporter. The second reference is to Jimmy and Jerry, two gourds that appear in the popular VeggieTales series of children's videos.
- At one point, Jimmy Jerry shouts "SQL Sam, you're the greatest!" This is a reference to the Tennessee Tuxedo cartoon. Tennessee Tuxedo and his pal Chumley would always go to Phineas J. Whoopie who would proceed to give them some simple explanation of how something complicated like an internal combustion engine worked. Armed with this new-found knowledge, Tennessee would announce "Phineas J. Whoopie, you're the greatest!" and then proceed to get into a great deal of trouble with the little bit of knowledge he had gained. Sound familiar?
SQL Sam and the Never-Ending Delete
- "Sam, stop this crazy thing!" is a reference to the end-credits of the Jetsons cartoon, where George gets caught on the automatic treadmill while walking his dog, Astro, and calls out "Jane! Stop this crazy thing!"
- Dana Nully and Fox Nullder are, of course, parodies of the two popular X-Files characters.
- "I believe the truth is in here" is a take-off of the X-Files catch-line "The
Truth is Out There."