Stack Overflow & AI

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...

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

Checking Myself with GenAI

I had a suggestion from somone on a place where AI helps them and I decided to try it. The person had an AI summarize their work and if...

Redgate SQL Prompt in SSMS 21

Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it, the new version of SSMS is now generally available. It’s a big new version and...

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