Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable period of imparting knowledge, or (B) a wonderful opportunity to hear me speak at any of several different venues.

Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable candidate. (Most of his responses started with “Well, there was this girl, and we were at a party….”). This, again, is an Un-SQL Friday topic if ever there was one! Read more

It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query. Here’s a quick demonstration of the power of a well-thought-out search clause on a date column. For this example we’ll use AdventureWorks… Read more

We’re going to have to figure out what astrological sign our SQL Server instance has – when it was “born” (installed) – before we can apply any kind of horoscope predictions. I’ll start with the base query… Read more