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.

Blog Post

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: )

354 reads

Blog Post

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

Blog Post

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: )

454 reads

Blogs

Reading JSON Data with Python

By

Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...

5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond

By

Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...

Dynamically Unpivot columns in SQL

By

Picture this, your data ingestion team has created a table that has the sales...

Read the latest Blogs

Forums

Crazy Interviews

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Crazy Interviews

The Query Traceflag

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Query Traceflag

Using Machine Learning Pipeline Execution Activity in Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item Using Machine Learning Pipeline Execution...

Visit the forum