I’m going to teach the world about SQL Server indexes, one event at a time. I’d love to have you join me at these three upcoming events — they’re all different, hope to see you there!
Take the SQL Server Index Quiz!
Thursday, September 17, 2015, 5 PM Pacific
Part of the free 24 Hours of PASS event
How well versed are you on SQL Server indexes? Join this free session to take a quiz on SQL Server indexes to test your knowledge on clustered indexes, nonclustered indexes, filtered indexes, and more! Register over at the 24 Hours of PASS website.
And by the way, if you haven’t taken our free quiz on SQL Server indexing, now’s the time. Take the quiz here, it won’t spoil the webcast.
Top (3) SQL Server Index Tuning Questions
Monday, September 28th, 10 am Pacific
Free webcast hosted by the clever robots that keep Brent Ozar Unlimited® running
Got questions about how to design indexes for performance in SQL Server? You’re not alone! Join Kendra to get answers to the top questions she gets about indexes. You’ll learn how to decide on key column order, how to tell if you should drop an index, whether it’s bad to use the clustered index key in your nonclustered index definition, and more. Bring your best index questions for Q&A and discussion! Reserve your spot now.
SQL Server Index Therapy Session – One Day Pre-Conference Event at the SQL PASS Summit, 2015
Tuesday, October 27, 2015 in Seattle, WA
You want to design indexes to improve SQL Server’s performance, but you’re concerned that you might create too many, not enough, or just plain “wrong” indexes. In this session, you will learn how to design effective clustered and nonclustered indexes to speed up your queries. You’ll tackle index design challenges to learn how to choose the right key and included columns and how to consolidate duplicate indexes. You’ll get practical tips to recognize when to use filtered indexes and indexed views and how to avoid the gotchas and pitfalls that make indexes slow down your queries. If you have two years of experience writing queries for SQL Server, this session will put you in control of your next index-design project.
This one-day session is $495, and full conference registration isn’t required. Reserve your spot on the PASS Summit website.
Need video training, or in-depth training?
- Brent teaches indexes in his “How to think like the Engine” 90 minute online video ($29)
- Kendra teaches you “How to Tune Indexes in SQL Server” in 6+ hours of online content ($299)
- Kendra and Jeremiah teach a full week of “Advanced Querying and Indexing” ($3995)