It’s been a year already and it’s time to head back to Kalamazoo for their SQL Saturday. We’re heading back to the same location on September 22 for another day of free training on SQL Server. Not only is the training free but it is also an opportunity to meet and network with local professionals and speakers from around the country. If you are looking for a good way to spend a Saturday learning about SQL Server for free – this is the Michigan event to do just that.
Taking a look at the speaker schedule, there is a rockstar list of speakers attending and presenting at the event, such as Brent Ozar, Tim Ford, Hope Foley, Arie Jones, Allen White, and many others. The “others” does include myself and I’ll be speaking on topic:
Discovering the Plan Cache: Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
It’s going to be a great day and I’m hoping that we’ll visit the Kalamazoo Beer Exchange for some more networking after the event. And YES! – I’m going to bring the unicorn mask. Josh Fennessy (blog | @joshuafennessy) would probably kill a garden gnome if I forgot it.