Conferences and Classes

Free Webcast on Dynamic SQL Pro Tips

Dynamic SQL is one of the most powerful tools in the database developer’s arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by leveraging better indexes. However, when done wrong, it’s extremely painful to troubleshoot. I’ve been working with…
Read More

What Should I Submit to the PASS Summit?

Our industry’s biggest conference, the PASS Summit 2020, just opened their pre-conference workshop call for speakers. I’m going to submit a couple of sessions, but I want to hear from you first: if you were going to try to convince your boss to buy you a pre-conference workshop at Summit, what would be the topics…
Read More
Mastering Index Tuning

Join Me in London for My SQLBits Pre-Con Workshop: Mastering Index Tuning

I’m teaching an all-new hands-on workshop, Mastering Index Tuning. I’m taking my favorite, toughest modules of my 3-day online class and condensing them down into a 1-day workshop. You’ll learn quick, easy techniques to use the right nonclustered indexes, filtered indexes, indexed views, and columnstore indexes that will work on SQL Server 2019, 2017, 2016,…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}