Level: Intermediate

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

Attendees choose from 25 possible topics - plus you'll walk away with all 25 code samples.

That's right—you choose! Kevin will show 25 possible topics on the screen, and the attendees vote on which topics will be covered. 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 you'll walk away with 25 code samples, even though we'll only cover a portion of them in the presentation.

You will learn:

• About the new language enhancements in SQL 2012
• Where sub-queries are necessary
• To gain some appreciation of performance optimization