22-25 April 2026 
SentryOne Real World Performance Bootcamp
2019TL; DR
A full-day of troubleshooting and performance tuning for SQL Server using both built-in tools from Microsoft and vendor tools from SentryOne. Follow along with us as we walk you through finding and fixing issues with memory, I/O, CPU, and much more!
Session Details
This full day seminar will teach you introductory, intermediate, and advanced techniques for troubleshooting (including detecting, diagnosing, and resolving problems) and performance tuning (discovering sub-optimal performance and making SQL Server faster) using a variety of SQL Server's built-in features, including Dynamic Management Views (DMVs), Profiler, PerfMon, and other free tools from Microsoft. In addition, we'll provide a license for SQL Sentry Essentials and use it to teach you how to multiply your productivity, efficiency, and effectiveness at one of the hardest tasks for SQL Server DBAs.
- Context: We begin with an overview of SQL Server's internals and architectural components to make sure everyone is on the same page.
- Essential Metrics: We explore wait statistics and performance monitor counters in SQL Server, the most important features built-in to SQL Server for troubleshooting and performance tuning.
- The Checklist: It's time to detect problems in our SQL Server! This checklist and methodology will help you get to the root-cause quickly and effectively.
- Group Lab: Based on what we've learned so far, we will conduct some live troubleshooting walk-throughs.
- Deep Dives: Intermediate problems solving and performance tuning requires more skill and information, especially the correlation of multiple data points. This segment of the seminar will teach you important DMVs and built-in tools, plus how and when to combine them together for even more powerful performance information.
- Get Proactive: Once you find a problem, don't be surprised by it again. This segment shows how to alert for future issues.
- Mining the Repository: If you're using SentryOne, you have a fantastic well of performance data to draw from. We'll show you how to explore all the performance history and trends of your system.
By the end of the day, you will have a more thorough understanding of SQL Server's internal behaviors, the main sources of performance metrics, how to interpret those metrics, resolve the most common issues and performance problems, and then build a means of proactively managing future problems through alerting. Come join us!
3 things you'll get out of this session
Speakers
Kevin Kline's other proposed sessions for 2026
Career Transition Workshop: From Technologist to Leader - 2026
Query Tuning Internals for the Advanced SQL Developer - Part 1 - 2026
Query Tuning Telemetry for the Advanced SQL Developer - 2026
Query Tuning Telemetry for the Advanced SQL Developer - Part 2 - 2026
Stop Firefighting! How to Beat the DBA Burnout Crisis - 2026
Kevin Kline's previous sessions
How to Conduct a Transact-SQL Code Review
Learn a collection of important best practice for Transact-SQL code and how to integrate them into your code acceptance testing for better performance and efficiency.
Shift-Left: A DevOps and Database Story
Database code often works well in a test environment, but end up causing significant performance issues when rolled out to production. In turn, these performance issues lead to lost productivity, excess resource consumption, and lost time spent troubleshooting the issue. But what if we could catch those issues during development? Join Kevin Kline to learn how SolarWind's SQL Sentry can shift performance tuning left to the dev cycle so those issues never occur on production systems in the first place.
SQL Horror Stories
Join Kevin Kline as he takes you on a guided tour of some of the worst and most horrible SQL coding experiences. Some were intention and some were accidental. But all of them will make you wince and laugh! Learn new SQL coding tips and tricks from these cautionary tales.
De-risk Your Azure SQL Migration: 5 Critical Considerations
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
Pitch Perfect-Presenting Ideas That Win Executive Support
You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?
Optimizer Secrets: Debugging using 860x Trace Flags
Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.
Ten 10 Query Tuning Techniques Every SQL Programmer Should K
Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.
Top 10 Mistakes of New IT Leaders
New IT leaders are rarely trained in the soft skills needed to be successful when put in charge. This one-hour session will explore the ten most frequent and challenging mistakes that new IT leaders make, as well as discuss methods for combating thos
An End-to-End Troubleshooting Checklist for SQL Server
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
Practical T-SQL Tips & Tricks to coding problems
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.
Top Ten Crucial Dev Skills to Make Your DBA Happy
Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration
Top 10 Administrator Mistakes on Microsoft SQL Server
Microsoft SQL Server is one of the easiest database to setup and administrate. But that doesn't mean it's problem free. Find out the most common DBA mistakes on SQL Server so that you can make sure not to make them!
Understanding and Preventing SQL Injection Attacks
SQL Injection attacks are one of the most common hacker tricks used on the web. Learn all about SQL Injection attacks in this perennially favorite session.
Understanding and Preventing SQL Injection Attacks
SQL injection can happen to you! But SQL injection is also very easy to prevent. Learn the ins and outs of SQL injection so that you don't become a victim.
Richard Douglas
Richard Douglas's other proposed sessions for 2026
Couchbase for the SQL DBA - 2026
Resource Governor: Reducing Dastardly Behaviour in SQL Server 2025 - 2026
TempDB: The Bottleneck You Can’t See in the Execution Plan - 2026
The Lifecycles of Queries: How SQL Server Really Executes Your Code - 2026
Richard Douglas's previous sessions
Improving SQL Server Performance with Indexing
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve
the overall performance of your apps
Investigate TempDB like Sherlock Holmes
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
Alerting; Beyond the Basics
We'll look at events that you should be monitoring, how you can use various services & IoT enabled devices to alert you in ways that were never possible. You'll leave with a new outlook of how teams can be notified to fix problems faster than ever.
The Big Backup Theory
In this session, you'll gain invaluable guidance for optimizing your backup strategies. Using trace flags the session will cover how SQL Server manages its own backup options and how you can tune them to meet your SLAs.
Wait watchers-Gain Performance Increases Fast!
In this session you'll learn all about SQL Server wait statistics. These are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions.
The Day After Tomorrow; Why You Need to Baseline
Ensuring top performance is never easy. To maintain performance you need to make sure you’re monitoring the right things. How do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.
Andy Yun
sqlbek.wordpress.com
Andy Yun's previous sessions
Can SQL Server 2019 auto-magically fix my bad T-SQL code?
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Advanced Plan Explorer Usage for Tuning Execution Plans
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Share Your Story: Developing Your First Presentation
Take an idea and learn how to develop your first session.
SentryOne Tools for Productivity and Performance
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
Uncovering Duplicate, Redundant, & Missing Indexes
Ensure your indexes are achieving their fullest potential!
Performance Pitfalls of Code Reuse
Learn how object-oriented T-SQL hurts performance.
Why Your Datatype Choices Matter
Learn how poor data type choices can cripple SQL Server.
