17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Programming T-SQL Enhancements in SQL Server 2012

As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL)—the native procedural programming language that developers have been using since the birth of the product. In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine.

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, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session!
Presented by Leonard Lobel at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    LenniProfile200.jpg
    Leonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. Programming since 1979, He is also a consultant, trainer, author, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, SQL Bits, CodeCamp, and other industry conferences worldwide. Lenni is also lead author of the MS Press book “Programming Microsoft SQL Server 2012.” He can be reached at lenni.lobel@sleektech.com.
    http://lennilobel.wordpress.com http://lennilobel.wordpress.com/rss
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.