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 talk about and demonstrate some of the new T-SQL features.

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

Speaker

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!!

Martin Bell's Sessions

What’s New in SQL Server 2008 T-SQL

Powershell - old tricks for a new dog?

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"

Identifying Performance Problems with SQL 2005 Profiler