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

364 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

3 reads

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

485 reads

Blogs

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

By

Recently, the world was reminded of just how fragile the internet can be.  Two...

Prepping for Certification, Part 4 of 4

By

In Parts 1-3, I covered how I prepare for a certification exam. In this...

Flyway Tips: Automation Assistance in Flyway Desktop

By

I was chatting with the product managers at Flyway and one asked me whether...

Read the latest Blogs

Forums

what are the downsides of TDE not running vs running?

By stan

hi for the 2 years i've been here I believe we've had "encryption" turned...

Help! MEMORY_ALLOCATION_EXT wait stalls

By krypto69

Hi I have an overnight process that moves allot of claims records Been working...

Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server

By ashok.gadiparthi

Comments posted to this topic are about the item Unlocking Data Transformation: My journey...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers