-
T-SQL Tuesday #192 – SQL Server 2025 Excitement
Read more: T-SQL Tuesday #192 – SQL Server 2025 ExcitementThank you to Steve Jones for repeat hosting T-SQL Tuesday this month again! This month we are talking about SQL Serve 2025, which I think we all expect to hit the shelves next week. Every new version of SQL Server, once I get access to the bits, I go to the What’s New page and…
-
Throwing Stuff at the Wall
Read more: Throwing Stuff at the WallOf late, if you are following my endeavors, you may have noticed that I am trying to pump out the content as fast as I can. This new website, 2 or 3 blogs a week, a podcast (and a writing vlog that I will start kicking out episodes very soon), and hopefully next year I…
-
25 Years
Read more: 25 YearsToday I celebrate 25 years with CBN. 25 years. Sometimes I have to let that sink in. I only know a few people who have had that kind of longevity with any company, well, other than a decently large number of my company-mates, who have been here considerably longer than I have, that is. In…
-
SQL Strategies for Comparing Sets of Data
Read more: SQL Strategies for Comparing Sets of DataThere are many occasions when we want to see the differences between two sets of data. Sometimes a whole table, a subset of a table, or even the results from a couple of queries, like in a unit test. Maybe you want to see that two sets are exactly the same, for example domain table…
-
Louis’s Scary Adventure: Podcasting the Challenges of Technology
Read more: Louis’s Scary Adventure: Podcasting the Challenges of TechnologyI have been working on a project the past few months, trying out the idea of having a podcast again about technology. Part of me is terrified, but I had wanted to do a podcast like this for a while now. Just me (for now), my microphone and camera, talking to myself. I picked this…
-
Temporary Stored Procedures: Outputting Status in Scripts
Read more: Temporary Stored Procedures: Outputting Status in ScriptsOn another connection (on another computer for that matter), I am right no doing some pretty long loads of some test data. The script is comprised of 6 queries, and they each may take 10 minutes (not completely sure, this is my first run of the scripts). And of course, I want to get some…
-
Are Technical Blogs Dying?
Read more: Are Technical Blogs Dying?As I sit here on a Sunday afternoon at my keyboard, looking for blogs to highlight, I notice something. A lot of people I know have blogs, and a lot of them are not active (or aren’t very active). I won’t name names or anything, but it is a bit depressing. There are a zillion…
-
Temporary Stored Procedures in SQL Server
Read more: Temporary Stored Procedures in SQL ServerPretty much every T-SQL programmer knows about temp tables very early in their journey with the language. They are generally wonderful tools that, when used properly, can be invaluable for storing data for a short amount of time. When used improperly they can be somewhat problematic, but certainly they are a tool we all use…


