Level: Introductory to Intermediate

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

Attendees will select from 25 possible topics to review in this session and walk away with 25 code samples.

That's right, attendees choose! I'll show 25 possible topics on the screen, and the attendees vote on which topics we will cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans, and even from the new analytic functions in SQL 2012 to common gotchas in T-SQL programming when aggregating multiple child tables. The good news is that you'll walk away with 25 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 subqueries are necessary
• Gain some appreciation of performance optimization