Level: Intermediate to Advanced
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