Level: Introductory to Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

In this informative and demo-packed session, Lenni will guide you through the latest T-SQL enhancements in SQL Server. We'll dive into powerful new windowing enhancements with the OVER clause, new T-SQL functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, rich metadata discovery techniques, and contained databases. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won't want to miss out on this session!

You will learn:

• New T-SQL features in SQL Server 2012
• Examine 22 new T-SQL functions, including 8 new analytic windowing functions
• Explore OVER, THROW, OFFSET, metadata discovery, and contained databases