What’s New in SQL Server 2008 T-SQL

SQL Server 2008 has plenty of new, improved and updated features including extensions to Transact SQL. In this presentation Martin will demonstrate some of the new T-SQL features including:

  • Row Constructors
  • Merge
  • Hierarchy Id Data Type
  • Sparse Column and Column Sets
  • Grouping Sets
  • Filestream Storage
  • User Defined Table Type
  • Table Valued Parameters
  • Date and Time Functionality
  • Dependency Reporting 
Presented by Martin Bell at SQLBits IV
Tags (no tags)
  • Downloads
  • SpeakerBIO
    Martin Bell has aged considerably since starting to organise the SQLBits conferences; but is still a dashing and attractive redhead. He's worked on many relational database management systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003 proving he is not just a pretty face! As an insight into his masochistic tendancies he currently organises the Scottish Area and Leeds Area SQL Server User Group meetings. He is also a founding organiser of the highly successful SQLBits Community Conferences conclusive proof that he is slightly mad!!
    http://sqlblogcasts.com/blogs/martinbell/ http://sqlblogcasts.com/blogs/martinbell/rss.aspx
  • Video
    The video is not available to view online.