Live Instructor-Led SQL Server Training Classes
Start your SQL Server learning journey here – no registration required. I see these as table stakes for anybody who works with SQL Server – developers, DBAs, data scientists, etc.
You’ve never had a formal SQL Server training class, and you want to learn how SQL Server builds your query results using indexes and statistics. Watch this free one-hour class now.
Fundamentals of Performance Tuning
You need to make SQL Server go faster, fast. I do this stuff in real life every week, and I can teach you how to make it happen.
The easiest way to make all of your queries go faster is to build the right indexes to support them. Learn how in one day.
You want to make your queries faster, but you’re not comfortable reading execution plans, finding the problems, and tuning T-SQL. Learn how in one day.
A query just suddenly runs slowly. Your fix is to update stats or rebuild indexes. It seems to work, but you don’t know why, and it keeps coming back. Understand why in one day.
You have a slow SQL Server, and you know the bottleneck is in there somewhere, but where? Learn how to measure and interpret wait stats, plus tune them, in 5 hours of videos.
Mastering Performance Tuning
You’ve conquered the fundamentals, and now you’re ready for brutally challenging hands-on labs.
You don’t have time to fix queries, and you need quick wins. Learn how to use my D.E.A.T.H. Method to fix indexes on an existing database, fast, in 3 days of live lab challenges.
You’ve conquered Fundamentals of Parameter Sniffing, and now you need to master all the different ways to mitigate parameter sniffing problems for good. I’ll show you in 3 days of nonstop demos.
Database Administration Training
Databases are harder than ever – with even more specialized topics to learn.
Remember that day when the senior DBA sat you down and gave you clear, specific instructions on how to handle SQL Server? No? Ah, that never happens. Erik will get you started.
You don’t go to a lot of job interviews, and you don’t really talk about what you do for a living. So how are you supposed to pass these things? I’ll show you how to ace it.
Want Lots of the Above?
Check out my bundles…of joy.