Coming up fast: SQL Connections Spring 2009 – indexes!

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!

OT: Scottish fine arts

(Yes I know I haven't posted for a while, we've been travelling – we're in Hyderabad right now – but I'll post a bunch over the next week)

This one's totally off-topic. My Mother is a popular and well-known artist in Scotland (described as "one of the new Scottish colourists") and she's just launched a website show-casing her paintings. Although you may think I'm promoting it because she's my Mom, its not just that – her paintings really are excellent and I own many myself. Checkout her website at


TechNet Magazine: February 2009 SQL Q&A column

OK – last content post today. I forgot that the February TechNet Magazine also has the latest edition of my regular SQL Q&A column. This month's column covers:

  • Should backup compression be enabled at the instance level?
  • Client redirection during database mirroring failovers
  • Partition-level lock escalation in SQL Server 2008
  • Is it ever safe to rebuild a transaction log?

Check out the column at