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

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

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

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