John Sterrett

I Make SQL Server go Fast

Austin, Texas, United States

John's experience leading large technical teams in complex environments has made him a global expert in performance and scalability. John speaks at conferences around the world on database strategy and topics related to performance tuning, development, and cloud computing. He is a Microsoft Certified Trainer, and former Microsoft MVP. He is the principal consultant and founder at Procure SQL.

Area of Expertise

Information & Communications Technology

Topics

SQL Server
SQL Server Development
SQL Server Indexes

Getting Started: Introduction to Azure SQL Database

First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is have a bad first impression. In this session, you will learn the difference between Azure SQL Database, Elastic Pools, Managed Instances, and Hyperscale. You will learn how to secure your data and also make your data highly available. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload overtime to make sure your users have a great experience while you save as much money as possible.

SQL Server Performance Tuning with Free Tools

Do you wish you could make your SQL Server or Azure SQL database queries go faster without paying for expensive tools? In this workshop, you will learn how to identify your slowly running queries and how to make them go faster. I will teach you not only how to use the tools but also the processes I use on a day-to-day basis to improve SQL Server workloads for over 50 different customers.

Tools covered include Query Store, Intelligent query processing, Plan Explorer, Extended Events, and open-source scripts.

Three things to know before going Independent

I have successfully gone from DBA to independent consultant to business owner. Betting on yourself might be one of the best bets you can ever make. My journey had bumps in the road. My ride could have been a lot smoother if I had help with these three things.

1. How do you find gigs?
2. How do you set your rates?
3. Why you should say NO!

Make Your SQL Server Queries Go Faster

Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, we will cover coding patterns that are developer-friendly but are not SQL Server database engine friendly. You will learn how to identify them and how to refactor your code so they will run faster.

DBA Basics: Getting Started with Performance Tuning

Have you ever found yourself in need of making queries go faster but didn't know where to begin? In this session, you will learn multiple ways to find your top offending statements. You will learn three key tips to help you understand execution plans. Finally, you will learn a framework to help you create indexes to help performance.