SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years. I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years. Since SQLTeach is part of DevTeach, the "feel" of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary focus. It does however afford an opportunity for me to understand the challenges of those who need to work with SQL either in a direct or indirect manner. SQLTeach / DevTeach records sessions and post them on the web for anyone to consume (login required, but a login may be created for FREE). Here is where I found this video: http://www.devteach.com/DevTeachVideo.aspx?NoVideo=45
The session that I selected to review is by one of my favorite speakers, Kimberly Tripp. In this session, Kimberly once again simplifies a concept that is often treated as black magic. The session is entitled "Optimizing Procedural Code". This demo-heavy session covers many different options that are available to impact optimization. Do you know the various options to force out a cached plan? Is recompiling bad? What else can I control to help optimization?
Check this session out and consider attending the next SQLTeach/DevTeach (especially if you are already in Canada).