Every SQL Server professional needs to understand not just what makes queries fast, but what makes them slow. This knowledge is essential whether you're aiming to become a performance wizard or trying to make those problematic queries stop holding up the business. By the end of this course, you'll have the tools and confidence to diagnose and resolve performance issues without resorting to guesswork or prayer.

This course is all about T-SQL. You'll learn how to write queries that return correct results, and don't make the server break down when they run. This material spans beginner to advanced, and includes concepts applicable to transactional and reporting workloads. Whether you're designing the next super high concurrency application, or working as a data scientist, engineer, or analyst, this course is for you.

All the videos! Over 24 hours of SQL Server performance tuning content, streamed directly to you. * Starting SQL (28 lessons) * Performance Tuning Essentials (29 lessons) * SQL Server Hardware (27 lessons) * Blocking and Deadlocking (11 lessons) * Advanced Query Tuning (86 lessons)

Get a SQL Server health check to quickly assess performance and stability issues. Just run my data collector, send me the zip file, and I'll go over all the numbers to produce a PDF document detailing short, medium, and long-term changes you can make to your SQL Server. You should choose this option if you're not comfortable making the changes on your own. If you are, choose the option without consulting hours.

Buy 20 hours of my time to dig into your SQL Server performance problems, and get hands on help solving them. Here's what I typically provide in my consulting engagements: * Correctly configured servers * Right-sized hardware * Efficient indexes * Optimized schema * Finely tuned queries * Resolved blocking and deadlocking * Well-trained database staff We can typically get started within a couple days of purchase.

Buy 40 hours of my time to dig into your SQL Server performance problems, and get hands on help solving them. Here's what I typically provide in my consulting engagements: * Correctly configured servers * Right-sized hardware * Efficient indexes * Optimized schema * Finely tuned queries * Resolved blocking and deadlocking * Well-trained database staff We can typically get started within a couple days of purchase.