John Sansom

John Sansom (Blog | Twitter) is a Microsoft Certified Master (MCM) of SQL Server and publisher of the free SQL community ebook DBA JumpStart, an inspiring collection of advice for Data Professionals, written by 20 SQL Server experts. Awarded the Microsoft Community Contributor(MCC) award, John is a prolific blogger and can be found regularly writing about SQL Server and Professional Development over at www.johnsansom.com.

Blogs

The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering

By

(This post starts a three-part series on how AI is changing the way we...

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

By

I built a free library of runnable SQL Server demos. Each reproduces a real...

Experimenting with CHOOSE: #SQLNewBlogger

By

I was looking over the CHOOSE() function while editing an article at SQL Server...

Read the latest Blogs

Forums

Managed Instance vs Azure Database - is this a good option?

By jasona.work

We're currently in Azure, however as we had a very tight migration timeline when...

MERGE in a nested TRY/CATCH won't roll back

By Pete Bishop

I have a section of code similar to the following abstract: DECLARE @loop [int]...

Perfermance result aftet purge operatio

By abdalah.mehdoini

Hello everyone, I am planning to implement a data purging solution that is expected...

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers