Database and Analytics

TH08 Programming the T-SQL Enhancements in SQL Server 2012


9:30am - 10:45am

Level: Introductory to Intermediate

Leonard Lobel



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