John Sterrett

johnsterrett.com/blog

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.

John Sterrett's Sessions

Three things to know before going IndependentSQLBits 2023

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!

Three things to know before going IndependentSQLBits 2023

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!

Building your first IndexSQLBits 2022

Learn a framework to use to successfully build your first index. Join us as we look at a query and go through 12 steps to identify which index will give the most improvement for our query.

DBA Basics: Getting Started with Performance TuningSQLBits 2022

Have you ever found yourself in need of making queries go faster but didn't know where to begin? You will learn how to find your top offenders, basics of execution plans and an index tuning framework to help you start as a performance tuner.

Getting Started: Introduction to Azure SQL DatabaseSQLBits 2022

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 which data platform offering is best for your application. You will learn the difference between Azure SQL Database, Elastic Pools, Managed Instances, and Hyperscale.

Make Your SQL Server Queries Go FasterSQLBits 2022

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.

Replay in the Cloud: Introduction to the SQL Server Database Experimentation AssistantSQLBits 2022

Capture your workload database on-premise or in the cloud Replay your workload on-demand as needed Analyze and compare results, giving you full confidence in the best outcome for Azure migrations