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

SQL Server 2025 Generally Available

By

This was announced last week at Microsoft Ignite and it's been covered by others...

Chatting with Power BI: Who Benefits from This Conversation?

By

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

A Quick Look at Redgate Data Modeler

By

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...

Read the latest Blogs

Forums

The Ending Substring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Ending Substring

Done is Better than Good

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Done is Better than Good,...

Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...

Visit the forum

Question of the Day

The Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

See possible answers