What's New in SQL Server 2012, For Database Administrators, For Developers

SQT08 Programming the T-SQL Enhancements in SQL Server 2012


2:00PM - 3:15PM

Level: Intermediate to Advanced

Leonard Lobel



Sleek Technologies, Inc.

In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of 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:

  • 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