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. I’ll teach you the most important advanced lessons in one day.
In my one-day Mastering Index Tuning online workshop at SQLbits, you’ll learn:
- My D.E.A.T.H. Method to quickly redesign indexes in an existing database
- How to use sp_BlitzIndex to Deduplicate & Eliminate indexes that need to get out
- How to use sp_BlitzCache to Add & Tune indexes based on your query workloads
- When to resort to Hand-crafted indexes like filtered indexes, indexed views, and indexed computed columns
The day will be 25% slides, 75% demos, and 100% useful for both cloud and on-premises installations. I’ll be using the Stack Overflow 2013 database, and you’re welcome to follow along: just have a laptop with SQL Server 2016 or newer, or have an Azure SQL DB instance with the Stack Overflow 2013 database already installed.
And because it’s being sold through SQLBits, everyone can attend!
- SQLBits.com – with dates, logistics info
- SQLBits pricing – it’s £300 for my workshop (available either Tues or Weds, 29-30 Sept), or £800 for the full conference with 2 workshops, plus all-day training on Thursday, Friday, and Saturday
- Register here – see you in class!
10 Comments. Leave new
The day I was waiting for… Unfortunately I have to go to work, so I cannot attend. Is there any chance it will be recorded?
No, sorry. Be there or be square.
Finally! See u there party person ?
Hey Brent! Any chance doing something similar to Brazil or maybe entire South America? 🙂
Hi! Sure, I do plenty of training classes that work for the Americas time zones. Just click Training at the top of the site and check out the classes you’re interested in. See you in class!
Thank god you are not cancelling your class!!! 🙂 I was afraid that i won’t be able to attend your class neither, being from EU (Paul Randal renounced to present)..Waiting for the day the class starts …
Hi Brent, quick question regarding SQLBits this year, training days: for 29 sept, the schedule for the event looks like you will present only half of day?!? It shows like the day is split between your session and Paul Andrew’s session. It’s confusing..Will 29 be also a full day like 30sept? Thanks
Hmm, I think you’re misinterpreting the schedule – may want to try another browser, perhaps.
Maybe, just wan’t to be sure before changing anything.. Can’t attach a picture from Chrome..So full day of training on 29…
Yep!