Modifying a Trigger to Capture More Info: #SQLNewBlogger

I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to...

Query Hints and Estimated Plans

I’m working on an update to my Query Performance Tuning book for SQL Server 2025 and I found myself wondering, will a query hint be immediately apparent in an...

SQL Server Login Types: Knowing the Difference Really Matters

If your SQL Server has both SQL and Windows logins and you’re not sure why, you’re not alone. Many IT teams without a dedicated DBA bump into this sooner...

T-SQL Tuesday #187–Solving Problems

This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he...

KDA: Echoes of Deception - Case 3

The crime spree in Digitown is not ending. This time 20 cars have been stolen and we need to find where they’re stored.
The problem
This is the abridged case description....

Monday Monitor Tips: Customizing Data Retention

One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross...

SQL Server 2025: Enterprise AI Without the Learning Curve

With the release of SQL Server 2025, Microsoft is firmly positioning its flagship database platform as an enterprise-ready AI solution. Having spent time with the preview builds and working...

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A Step-by-Step GuideBuilding scalable, portable, and easy-to-maintain applications has become necessary in today's...

Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide

C++ is a highly versatile language for developing console applications, batch processing, and performance-critical applications. While it has traditionally been less explored for building RESTful APIs, modern libraries like...

T-SQL Tuesday #186 Roundup - Managing Agent Jobs

Thank you to everyone who contributed to this month’s T-SQL Tuesday!

Here’s a roundup of the posts.