-
The logical lifecycle of a query
Read more: The logical lifecycle of a queryThere have been a lot of posts on LinkedIn of late about the “logical execution order” of a query that all really miss some really big points. I was corrected myself in some terminology because I mistook the term “processing” to mean the same as “order” in these discussions when I was explaining why logical…
-
Scenic City Summit 2026 Roundup
Read more: Scenic City Summit 2026 RoundupThe conference has passed, and what a great couple of days it was. During the lead up to the conference, we had a few minor snafus, like some ticketing platform issues and near the conference, our website would throw up a delightful message: We’re having trouble connecting This was happening about half the time when…
-
What exactly does normal mean?
Read more: What exactly does normal mean?A word we use all the time is “normal.” In math it means a line going perpendicular to a line or a plane. Until I was sitting here now, I never really asked “why is a normalized database normal?” If you have ever seen a database that is well designed, you can be assured that…
-
Scenic City Summit 2026
Read more: Scenic City Summit 2026It is that time again when we gather in Chattanooga, TN for Scenic City Summit. This is a conference I have spoken at a few times, and have been one of the organizers for the past two years. This conference has a variety of subjects, but like most tech conferences, this year the topic of…
-
Raleigh Day of Data 2026 Roundup
Read more: Raleigh Day of Data 2026 RoundupAnother year, another awesome conference put on by Kevin Feasel here on Memorial Day weekend. Kevin joked about not realizing it was Memorial Day when he set the date, and to be honest, I didn’t realize it either. I had asked off for Monday with a pretty detailed plan of why and what my plans…
-
I have NULL issues with NULL
Read more: I have NULL issues with NULLThere is no simpler topic in relational comparisons than three valued logic. I am being mostly facetious about this, but in reality, it seems so simple that people don’t think about how a NULL works, and make mistakes all of the time. I was reading a post about this the other day on LinkedIn (which…
-
Raleigh Day of Data 2026 this week
Read more: Raleigh Day of Data 2026 this weekFor my last scheduled conference of the year, (I have hopes of doing at least one more in September/October, but that is TBA…based on when that conference is scheduled and if they need someone to talk about SQL!) This will be my second trip to Raleigh and my second year in a row as well.…
-
All of your code is right
Read more: All of your code is rightI am kind of weird. I love clickbait. It is the simplest (and cheapest) form of gambling. I see a headline that says “Walt Disney World is closing all operations immediately” and I have to click on it, after I guess what it is means. If you clicked on this with the morbid curiosity of…
-
T-SQL Tuesday #198 – How Do You Detect Data Changes?
Read more: T-SQL Tuesday #198 – How Do You Detect Data Changes?Finally, a T-SQL Tuesday post that isn’t all introspection. There will be some because some of the reasons I never tried certain features for detecting change in data is odd considering my love of testing/using features myself. Thank you to the wonderful Meagan Longoria for this invite this month. For the past year, T-SQL Tuesday…
-
Day of Data Jacksonville 2026 Roundup
Read more: Day of Data Jacksonville 2026 RoundupDay of Data Jacksonville 2026 (#1128) is now over and what a great time it was (as usual). I added a vacation stop along the way, so this post is coming out a week later than desired, but that is still much better than the last few have been! We started the trip down Thursday,…
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
