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

Join us for FryeDay!

Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server and Microsoft Data Professionals to gather to connect,

Frye First Time Speaker

share and learn.

I will never forget being anxious and scared the first time I gave a presentation… Read more

0 comments, 107 reads

Posted in John Sterrett on 7 November 2018

Best Hidden Feature in SQL Server 2019

With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet.  Most likely if you are following along you have heard of Big Data Clusters, Spark, Performance Tuning, and security features.  I am really excited about this new feature and hope you are… Read more

0 comments, 341 reads

Posted in John Sterrett on 26 September 2018

SQL Server Automatic Tuning in the Real-World

In SQL Server 2016 we saw Query Store.  Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster.  Microsoft’s marketing team even jumped on to help coin the phrase, “SQL Server It Just Runs Faster.” With… Read more

1 comments, 2,622 reads

Posted in John Sterrett on 10 September 2018

Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th

Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was to remix the song I would just change the word “Havana” to “Wheeling, WV” because half of my heart is in… Read more

0 comments, 1,405 reads

Posted in John Sterrett on 29 March 2018

Finding Top Offenders with Extended Events

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get insight into the top offenders.… Read more

1 comments, 233 reads

Posted in John Sterrett on 6 March 2018

T-SQL Tuesday #096: The Group Who Changed My Career Forever!

T-SQL Tuesday #96: Folks Who Have Made A Difference

Today’s blog post is about T-SQL Tuesday.  If you haven’t seen T-SQL Tuesday before its a great monthly call for all SQL Server bloggers to write about one topic that always changes from month to month.  In this months installment,… Read more

1 comments, 868 reads

Posted in John Sterrett on 14 November 2017

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.  Today, I want to focus on two small underdog features that might be… Read more

3 comments, 2,459 reads

Posted in John Sterrett on 31 October 2017

Talking about Migrating to Azure SQL Database at #MSIgnite this week

Speaking on Migrating to Azure SQL Database at Ignite 2017

This week I will have two talks on migrating existing database to Azure SQL Databases at Microsoft Ignite.  If you are there and curious about migrating your existing databases we would love to talk with you.

If you are attending… Read more

0 comments, 321 reads

Posted in John Sterrett on 25 September 2017

Blue Screen Your SQL Server On-Demand

These days I do a lot of testing with SQL Server.  When I am testing new features or helping clients implement SQL Server High Availability solutions I want to have several tests including blue screens.

Simulating blue screens actually might be much easier than you think.  For example, you can… Read more

0 comments, 585 reads

Posted in John Sterrett on 10 March 2017

Looking Back: 2016 was Awesome!

With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different reasons, both personally and professionally. It’s nice just to stop and acknowledge some significant accomplishments that occurred last year!

2016 in…

Read more

0 comments, 375 reads

Posted in John Sterrett on 5 January 2017

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

3 comments, 874 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

5 comments, 1,630 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

12 comments, 1,997 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, 519 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, 2,043 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, 441 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, 421 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,760 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,718 reads

Posted in John Sterrett on 9 April 2015

Older posts