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

Daily Coping 26 Sep 2022

By

Today’s coping tip is to enjoy photos from a time with happy memories. On...

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Read the latest Blogs

Forums

Replication Error on identity Column : Transactional Replication

By Tom257

  I have manually deleted data from a subscriber replicated table, and broken replication....

Two fact tables related

By Maria

Hi all, I have a couple of modelling questions using several star schemas. There...

Date conversion

By JSEYMOUR50@YMAIL.COM

Morning, I am trying to write a script which will display a date as...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using R apply

See possible answers