Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

John Sterrett

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

Adding a VLDB database to an SQL Server Availability Group

Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following, is how I successfully completed adding the very large database (VLDB) to an Availability Group that had two replicas in the primary data center and a third replica in another… Read more

4 comments, 985 reads

Posted in John Sterrett on 18 August 2015

Converting identifiers into SQL Server table variables in Management Studio

If I had a nickel for every time someone gave me a list of identifiers and asked me to pull a result set for them I would be a very wealthy man. Over the years this is an endless request. I used to use several different tools like excel for… Read more

2 comments, 5,083 reads

Posted in John Sterrett on 9 April 2015

Free Video for Accidental DBA’s

Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills that are necessary for accidental DBA’s to master to become DBA’s with a successful long lasting career.

I wish I had all this advice when I started as a SQL… Read more

1 comments, 1,340 reads

Posted in John Sterrett on 18 February 2015

Building Your First Windows Azure Machine

Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted out on This tip was my first one working with Azure.  To me its remarkable how quickly you can spin up an instance to help you build…

Read more

0 comments, 242 reads

Posted in John Sterrett on 17 December 2014

Get A Free SQL Server 2014 Book!

I have some great news to share. One of my bucket list items is to be a published author. I can now check this off my list. Coming very soon you will be able to buy the book that I helped write.  I will add links here once its on Read more

0 comments, 301 reads

Posted in John Sterrett on 2 October 2014

Unplanned Availability Group Failover

Whenever a disaster occurs it will be a stressful scenario regardless of how small or big the disaster is. This gets multiplied when it is your first time working with a newer technology or the first time you are going through a disaster without a proper run book. Today, were… Read more

0 comments, 316 reads

Posted in John Sterrett on 9 June 2014

Learn High Availability and Disaster Recovery with SQL Server in a Day!

If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT) 

Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like: Read more

0 comments, 371 reads

Posted in John Sterrett on 23 April 2014

Where is my Availability Group?

In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the covers it can be harder to figure out the following two questions. When did the availability group failover? Where did the availability group go when the failover occurred? The goal… Read more

0 comments, 1,371 reads

Posted in John Sterrett on 18 March 2014

T-SQL Tuesday #50: Automation for LazyDBAs!

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month.

T-SQL Tuesday 50 – Automation

This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month. This… Read more

0 comments, 327 reads

Posted in John Sterrett on 14 January 2014

Throwback Thursday #3: SQL Server & Disks

I hope everyone is having a good time gearing up for the holidays.   Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some great content on a single subject and share it with you.  In the third installment of the Throwback Thursday… Read more

1 comments, 358 reads

Posted in John Sterrett on 12 December 2013

Throwback Thursday #2: Get Your Speak On!

I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I hope you enjoy my second blog post in the Throwback Thursday series. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some… Read more

0 comments, 355 reads

Posted in John Sterrett on 28 November 2013

I’m A SQL Server Rockstar Blogger!


SQL Server Rockstar Blogger

I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server Blogger rankings I have always wanted to be on that list. Today, that happened. To many it might seem like a small accomplishment towards bigger accomplishments. Right… Read more

4 comments, 396 reads

Posted in John Sterrett on 27 November 2013

Throwback Thursday #1: SQL Inspire

What Is Throwback Thursday?

One of my hobbies is being a turntablist. In high school I took a job just so I could buy myself two Technics 1200’s, crates full of records and a mixer. I love scratching, beat juggling, and mixing accapella tracks over instrumentals. The radio… Read more

0 comments, 293 reads

Posted in John Sterrett on 14 November 2013

SQL Server Performance Root Cause Analysis in 10 Minutes

This year I was honored to be selected by Dell Software to present a ten minute session in their booth (#200) at the 2013 SQL PASS Member Summit. I decided to share how I do a SQL Server Performance Root Cause Analysis in 10 minutes with the SQL Community. Read more

6 comments, 437 reads

Posted in John Sterrett on 15 October 2013

Finding Top Offenders From Cache

When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find the queries causing the top waits. Next, I like to understand what is running and monitor disk latency. Finally, I would like to probe the cache to see… Read more

0 comments, 833 reads

Posted in John Sterrett on 14 October 2013

What Queries are Causing My Waits?

In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once I have found my top wait types is to use extended events to figure out the SQL statements causing the majority of the waits for those wait types.… Read more

5 comments, 3,352 reads

Posted in John Sterrett on 10 October 2013

Benchmark SQL Server Wait Statistics

One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid) changes its status from running to suspended it is typically due to resource wait or a signal wait. For example, you are typically waiting on PAGEIOLATCH_SH when you run a… Read more

10 comments, 937 reads

Posted in John Sterrett on 8 October 2013

Learn SQL Server Performance Tuning Basics in a Single Day

Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction to SQL Server Performance Tuning training opportunity for you in Pittsburgh on September 13th. It will be given as a PreCon for SQL Saturday #250 in Pittsburgh. Konstantin… Read more

0 comments, 2,307 reads

Posted in John Sterrett on 28 August 2013

Workload Tuning: Finding Top Offenders in SQL Server 2012

I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance tuning usually starts with finding your top offenders so you can get the biggest bang for your tuning bucks. For the first time, you can capture a workload using… Read more

1 comments, 1,837 reads

Posted in John Sterrett on 7 August 2013

First Look: Microsoft SQL Server 2014

Last week at TechEd 2013 in New Orleans Microsoft publicly released details about the SQL Server 2014 CTP 1. Here are some good reads about the information shared by Microsoft and the blogsphere.

Microsoft Info

Signup for 2014 CTP 1 bits ->

Hekaton White Paper for CTP1 -> Read more

0 comments, 1,239 reads

Posted in John Sterrett on 11 June 2013

Older posts