Let’s make your Microsoft SQL Server faster and more reliable together.
Brent’s Live Lab Classes
Brent shows you how to make SQL Server go faster while you work alongside him in VM labs.
You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. Good news – I’ll teach you how in 3 days of labs, learning, and fun.
Live Training Classes
Taught by folks who aren’t reading from a book: they’ve done it in real life, and they have fun with the topics.
We’ll take you from no data science knowledge to understanding the fundamentals and being able to put them into production using SQL Server. Taught by MVP Stephanie Locke with a decade of BI and data science experience. Learn more and register.
For SQL Server Integration Services (SSIS) professionals responsible for developing, deploying, and managing data integration at enterprise-scale. Taught by Andy Leonard, published author, Data Philosopher, and BimlHero. Learn more and register.
Daily maintenance tasks got you down? Ever wanted to automate your busy work away, but you weren’t sure where to start? Drew Furgiuele’s done automation for over a decade, and he’ll teach you PowerShell in two days of hands-on labs.
You don’t have the luxury of time to read PowerPoints and study theory. In a fast-paced 4-hour session, world-renowned presenter Pinal Dave shows you how to get indexes and server settings right, fast.
Performance Tuning Videos
Training that’s ready whenever you are, streamable to your phone, tablet, or computer.
How to Think Like the Engine – This should be the first class everyone sees about databases, and it’s totally free. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results. 90 minutes.
T-SQL Level Up: Level 1 – This course is designed for junior SQL Server developers and app developers who want to take their T-SQL skills to the next level up, and have a little adventure in the process. We help you write efficient T-SQL code by covering thinking in sets, CASE expressions, computed columns, and windowing functions. 90 minutes.
T-SQL Level Up: Level 2 – not every tuner can change the queries, but when you can, this is your next move. We’ll show you how to read execution plans, find the problems, and then mitigate them with CTEs, dynamic SQL, functions, parallelism, and sargability. 5 hours.
Diagnosing Slow SQL Servers with Wait Stats – forget Perfmon counters. It doesn’t really matter what your disk queue length or page life expectancy is, believe it or not. What matters is what your SQL Server is waiting on when it’s executing your queries. We’ll show you how to collect that data and interpret it. 2 hours.
How to Design and Tune Indexes – for common wait types like CXPACKET and PAGEIOLATCH, the most effective fix is tuning indexes. We’ll show you how to design the right indexes from the start, then use advanced features like filtered indexes and indexed views. 10 hours.
Statistics: SQL Server’s Guessing Game – when SQL Server builds your query plans, it starts by estimating how many rows will come back from each of the tables involved. It’s way, way harder than it sounds, and you can make a huge difference in your query performance once you understand how SQL Server uses statistics. 2 hours.
Query Plan Analysis and Tuning – finally, you’ll dig more deeply into query plans to look at join types, predicates, windowing functions, and common plan problems. 6 hours.
Start improving your database administration skills right now.
DBA Fundamentals – the classes that you really wish someone would have taught you when you first took this job, like how to check for corruption, how to send alert emails, and choosing your RPO and RTO.
Senior DBA Class – You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. 16 hours.
DBA Job Interview Questions & Answers Kit – database administrator interviews are really challenging because often the interviewer doesn’t really know what a DBA does. We’ll give you dozens of questions that we ask for our own clients, and we explain what we’re looking for in the answers. 90 minutes.