Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

I'll show 30 possible topics on the screen, and the attendees vote on which topics we will cover.

That's right, attendees choose! I'll show 30 possible topics on the screen, and the attendees vote on which topics we will cover. Everything from isolation levels to ranking, table-valued functions, querying temporal data, instances where sub-queries are necessary, update triggers, reading execution plans, and even the new analytic functions in SQL 2012 along with common gotchas in T-SQL programming when aggregating multiple child tables. The good news is that you'll walk away with 30 code samples, even though we'll only cover a portion of them in the presentation.

You will learn:

• The new language enhancements in SQL 2012
• Where sub-queries are necessary
• Gain some appreciation of performance optimization