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.

Speaking at the NYC Lunch and Learn DevOps Devour Hour

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus a happy hour. I’ll be there with Kendra Little and Erik Darling talking about DevOps...

What’s new in SQL Server 2025 CTP 2.0

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0) was announced, I was a few months in at the SQL Docs team, and had...

Monday Monitor Tips: Beyond SQL Server

Redgate Monitor works with more than SQL Server. Some big changes were announced recently, and I’ll cover the highlights here. This post looks at Redgate Monitor and the additional...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots on Pure Storage FlashArray, all from within SQL Server, no external tooling. SQL Server 2025...

Getting Started with Vector Search in SQL Server 2025 Using Ollama

Ollama SQL FastStart streamlines the deployment of SQL Server 2025 with integrated AI capabilities through a comprehensive Docker-based solution. This project delivers a production-ready environment combining SQL Server 2025,...

Getting Started with Vector Search in SQL Server 2025 Using Ollama

Ollama SQL FastStart streamlines the deployment of SQL Server 2025 with integrated AI capabilities through a comprehensive Docker-based solution. This project delivers a production-ready environment combining SQL Server 2025,...

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...

Query multiple Azure SQL Databases

I was sick of changing context in Azure Data Studio while cleaning up things discovered in our vulnerability assessments. Changing things via PowerShell I wanted to be cautious with...

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....