This year it looks like we're not going to be involved in TechEd US in May so the SQL Connections show in Orlando in March (21-26) will be the best way to pick up some of our training in the first half of the year. We are planning to do some Immersion events in various locations around the world (including the US) in the second half of 2009, so watch the blog for announcements.
Anyway, at this Connections Kimberly and I are going all-out on indexes - here's what we've got planned:
-
A full-day pre-con workshop on index internals, statistics, and fragmentation (2000, 2005, 2008)
-
A full-day post-con workshop on analyzing your indexing strategy - looking for extra, missing, or unhealthy indexes and dealing with them (2000, 2005, 2008)
-
A session by Kimberly on tuning indexes for various search arguments, joins, and aggregates (i.e. indexing for performance)
-
A session by Kimberly on sparse columns and filtered indexes in SQL Server 2008
And apart from indexing-mania, we'll have sessions on surviving database corruption and effective database maintenance. Our plan is to have AS LITTLE OVERLAP AS POSSIBLE between all these sessions and workshops - that's a lot of material!
Of course, Bob Beauchemin will be there with a plethora of developer-centric topics (including a full-day pre-pre-con on spatial data) and a bunch of other top SQL speakers that we've pulled together to create a great show.
Checkout out our Upcoming Events page for all the abstracts and details on how to register.
Hope to see you there!