John Sterrett
I Make SQL Server go Fast
Austin, Texas, United States
Actions
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.
Links
Awards
Area of Expertise
Topics
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.
KCDC 2024 Sessionize Event
SQL Saturday Atlanta 2024 Sessionize Event
SQL Saturday Austin 2024 Sessionize Event
SQL Saturday Atlanta 2024 - BI & Data Analytics Sessionize Event
KCDC 2023 Sessionize Event
2023 Data.SQL.Saturday.LA Sessionize Event
SQLBits 2023 - General Sessions Sessionize Event
PASS Summit 2022
PASS Data Summit 2022
SQL Saturday Jacksonville #1022 Sessionize Event
PASS Data Community Summit 2021 Sessionize Event
John Sterrett
I Make SQL Server go Fast
Austin, Texas, United States
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top