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.

SQL Server Crossword #5

When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...

2013-08-08 (first published: )

1,445 reads

Blogs

Daily Coping 16 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Running a .sql script file.

By

As with all programming tasks there are a number of ways to do something,...

sp_RestoreScript 1.9 – a dirty little bug squished!

By

It look like we had a little bug in sp_RestoreScript that was putting a...

Read the latest Blogs

Forums

Multiple instance on SQL server 2017 with VS 2019.... ERROR 26 on Visual Studio

By Charitto95

I have a system with multiple clients and each one in different virtual machines,...

SSRS 2017 How to check which SSL cert is bound

By webrunner

Hello experts, I need to update the SSL certificate on our SSRS 2017 instance....

Rebuild index

By Chitown

I have a table which is partitioned (Total 10). The table is 1.6 TB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers