SQL Server Tools, Tricks, and Techniques

SQT06 Programming the T-SQL Enhancements in SQL Server 2012

11/19/2013

11:00am - 12:15pm

Level: Intermediate

Leonard Lobel

MVP

CTO

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:

  • 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