Level: Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

SQL Server 2014 doesn't add much to T-SQL, but SQL Server 2012 enhanced the database's native programming language with numerous features. If you're not up to speed, this informative and demo-packed session will guide you through the powerful 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 genera-tors, rich metadata discovery techniques and contained databases. If you want to program the latest T-SQL enhancements in SQL Server, you won't want to miss 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 data-bases