John Sterrett is very active within the SQL Server community. He is a PASS Regional Mentor for the South Central Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally, PASS Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at http://johnsterrett.com.

Free SQL Data Compare

I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority...

2020-04-20

68 reads

Query Store for Workload Replays

UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL...

2020-03-19 (first published: )

345 reads

Previous SQL Server Updates

Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog...

2020-01-20 (first published: )

446 reads

Blogs

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

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

Read the latest Blogs

Forums

Formatting issue with percent

By JeremyU

I have an issue that may be an easy fix for someone, but is...

SQL Server connection using Get-StoredCredential

By ram302

Hi, I am currently able to log in using a trusted connection. I stored...

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

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers