PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)

Originally published in 2023, this post never made it into Google's index, so I'm republishing it...

How Fabric Mirroring Transformed with SQL Server 2025

When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL...

March 2026 SQL Server Security Updates

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released patches for SQL Server to address privilege escalation vulnerabilities in supported versions. Time to patch!

Monitoring Fabric Mirroring for SQL 2025

I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...

The 2026 Redgate Summit in New York City

We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You...

ADF Pipeline Debugging Fails with BadRequest – The Sequel

A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...

AI: Blog a Day – Day 7: Vector and Vector Databases

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...

EightKB 2026

EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...

Finding and Updating Duplicate IDs: #SQLNewBlogger

Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...

Monday Monitor Tips: Intelligent Alert Thresholds

At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert thresholds in Redgate Monitor and decided to write a little about this. This is part...