-
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,…
-
The Fun of Aging
Read more: The Fun of AgingThis is more or less a personal pep talk to myself as I navigate a few months of activity outside of the normal work week and I was feeling down as I was starting the second day of my vacation. Talking about it helped me so I started typing. Hope it helps you to realize…
-
Day of Data Richmond 2026 Roundup
Read more: Day of Data Richmond 2026 RoundupA few weeks ago, I did something insane. I wrote and presented a new presentation at Day of Data Richmond 2026. More on that in a minute. This was my second year in a row in Richmond and this year hit a bit differently, and also exactly the same. Jamie Wick was not completely in…
-
FABCON/SQLCON and SQL Saturday Atlanta BI Roundup
Read more: FABCON/SQLCON and SQL Saturday Atlanta BI RoundupI am fine to admit it, this roundup took WAY longer than I had hoped and is almost silly to post at this point. The same can be said for the series of videos I was posting daily on Instagram which took a week after the conference was over to post. There is a good…
-
Day of Data Jacksonville 2026 is this weekend
Read more: Day of Data Jacksonville 2026 is this weekendThe week is here, time to head south for the largest free conference I go to each year. SQL Saturday, I mean Day of Data Jacksonville. (It is going to take a while to stop calling it SQL Saturday!) has 12 concurrent tracks, over 5 time slots, some great pre-cons and well, some legendary snacks…
-
Taking a short break…
Read more: Taking a short break…I was looking at my screen the other day, and I thought, I need a break. Not a long one, but working a full time job, preparing sessions and traveling to conferences, tech editing a book, and just various life, health, exercise, vacation time challenges just made me say… I need to take a little…
-
The second (and most important) software test
Read more: The second (and most important) software testThere is an old computer science adage that the sooner you find a bug, the less impact it has. In this post I want to talk about the first test that every programmer does, and why you need to be as purposeful with this test as possible. No matter who you are, or how well…
-
T-SQL Tuesday #197 – An impactful session or two from a conference
Read more: T-SQL Tuesday #197 – An impactful session or two from a conferenceThis month the host is Steve Hughes/Data on Wheels. His topic idea is “to tell us about one or more things you learned at ANY conference you have attended that has impacted you or how you work.” Here is the link: This is a really great invite and it really made be (continue) to ponder…
-
SUBSTRING Optional Length In SQL SERVER 2025
Read more: SUBSTRING Optional Length In SQL SERVER 2025Sometimes along comes a feature that seems so obvious, so natural, that you wonder why it took so long for Microsoft to implement it. One of those features in SQL Server 2025 is the optional length parameter in the SUBSTRING function. It has long been one of those questions when you wrote a SUBSTRING expression…


