Worried about blocking in SQL Server? It takes a lock to cause a block! In this video course, you'll learn all the best query and index tuning techniques to avoid the locking and blocking that blow up your alerts and prevent your users from accomplishing anything. 70 Minutes, Streamed

In this course, I want to teach you about common performance problems you can solve by index tuning SQL Server, and how you can use your query plan and a little brain meat to figure out exactly what you need to do. Most people only worry about an index when it’s fragmented, or when they see a scan instead of a seek. And boy howdy, are they wrong about that! 100 Minutes, Streamed

You've got slow queries, and you're not sure where to start hunting down problems. Start here to learn about the more common, easy to fix issues you'll see. In this query tuning guide, you'll learn how to improve SQL Server performance. We’ll cover issues like implicit conversion, SARGability, parallelism, lookups, and more! You'll also get a gentle introduction to how the optimizer works. 120 Minutes, Streamed