Level: Introductory to Intermediate
Kevin Goff
Microsoft SQL Server MVP
Practice Manager
SetFocus, LLC
In this session, Kevin will show 25 possible topics and attendees vote on which topics to cover.
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, 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 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 sub-queries are necessary
- Gain some appreciation of performance optimization