4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Whats new in SQL Server 2012-TSQL

With the release of SQL Server 2012, the T-SQL language has been extended further to enable greater productivity and more optimal queries. Following the ANSI SQL standard support has been included for PAGING and SEQUENCES. Many cumbersome sub-queries will be banished by the clutch of new analytic functions, but perhaps the biggest is the window framing extensions. These now allow a true sliding window of data to process such common problems as rolling balances. This will be a high-level look session, but will be diving a bit deeper to highlight some caveats as we go as its not all plain sailing.
Presented by Dave Ballantyne at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dave_ballantyne.jpg

    Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England.  He is a regular speaker at UK and European events and user groups and currently is supporting the London SQL community by organizing the "SQL Supper" user group.  He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query.  He has also created an open sourced add-in for SQL Server data tools (SSDT) called "TSQL Smells".  This detects and reports on 'suspect'  code within a project and can be found at http://tsqlsmellsssdt.codeplex.com . Outside of work he is husband, father of 3 and exasperated archer.

    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.