Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 http://johnsterrett.com.

Three Reasons Why I Am Attending PASS Member Summit 2016

Three reasons why I am attending PASS Member Summit in 2016

Over the past few weeks, I saw on social media that many of my #sqlfamily members were not attending the PASS Member Summit conference this year.  It made me want to blog about why I am attending this year. Read more

0 comments, 110 reads

Posted in John Sterrett on 26 October 2016

Benchmark Azure SQL Database Wait Stats

Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database.  In the past, I blogged about how you should benchmark wait stats with the box product.  This process will give you misleading data in Azure SQL Database.  You will want to focus… Read more

2 comments, 313 reads

Posted in John Sterrett on 30 August 2016

Calculating DTU in Azure SQL Database

A few months ago, I posted a question over on ask.sqlservercentral.com.  In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL?  No one answered, so this motivated me get off my butt and answer my… Read more

2 comments, 907 reads

Posted in John Sterrett on 24 August 2016

Azure SQL Database Live Migrations

Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on an Azure SQL Database server.  We are talking about Microsoft’s database as a service (DaaS)  offering, not Azure VMs also known as infrastructure as a service (IaaS).  The only current… Read more

8 comments, 1,192 reads

Posted in John Sterrett on 26 July 2016

I am a Microsoft Data Platform MVP

My First Microsoft SQL Server MVP Award

Today, I have achieved an SQL Someday moment.  I am excited to share some exciting news. Microsoft has chosen me to receive the Microsoft “MVP” award. I am completely shocked as this is my first time obtaining this award.

It is a… Read more

6 comments, 225 reads

Posted in John Sterrett on 1 July 2016

Automatic Seeding Very Large Databases in SQL Server 2016

There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new features.  Being that I am the founder of the High Availability and Disaster Recovery Virtual Chapter, I plan on blogging about the new availability group features.

Today, I wanted… Read more

1 comments, 1,587 reads

Posted in John Sterrett on 29 June 2016

Automating Azure Resource Management Authentication

I love Azure and I love PowerShell.  They are a perfect marriage. It’s amazing how much automation you can do inside of Azure with some PowerShell scripting. In fact, you hardly see me using the Azure Portal these days.

Automation is great until manual processes are required. I have been… Read more

0 comments, 152 reads

Posted in John Sterrett on 23 June 2016

3 Reasons to Attend SQL Saturday Austin on Jan 30th

The Austin SQL Server User Group will host its third SQL Saturday on Saturday,

SQL Saturday Austin on January 30th, 2016

January 30th. SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free ($15 for lunch), all… Read more

1 comments, 237 reads

Posted in John Sterrett on 12 January 2016

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, 1,389 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,406 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,558 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 SQLAuthority.com. 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, 355 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, 429 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, 486 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, 636 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,842 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, 497 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, 477 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, 593 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, 622 reads

Posted in John Sterrett on 27 November 2013

Older posts