30th September - 2nd October 2010

University of York

RSS
Login or Join
Skip Navigation Links
Skip Navigation Links
Home
SQLBits 7
Register
Agenda
Booking & Pricing
Training Day
Friday
Sessions
Speakers
FAQ
Travel & Accommodation
Sponsorship
Gold Sponsors
Exhibitors
News
Previous Events
SQLBits The 6th Sets (VI)
Sessions
Speakers
SQLBits goes West (V)
Sessions
Speakers
SQLBits goes Forth (IV)
Sessions
Speakers
SQLBits Cubed (III)
Sessions
Speakers
SQLBits II The SQL
Sessions
Speakers
SQLBits I
Sessions
Speakers
About
About SQLBits
Who's Who
Privacy
Contact
Community

Brought to you by the UK SQL Server Community.

Copyright © 2007-2010 SQLBits. All Rights Reserved.

Telerik

Orcsweb

Gold sponsors
    
Silver sponsors
    
Bronze sponsors
    
    

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 

Speaker focus

Martin Bell

head.jpg
Martin Bell is a dashing and attractive redhead and you would never guess that he has been a freelance computer consultant in the UK for over 23 years. He’s worked on many relational database 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 showing he is slightly mad and very funny!!

Martin Bell's blog http://sqlblogcasts.com/blogs/martinbell/


Downloads

File Type Ext ContentName
Presentation .pptx Slide Deck
Zip File .zip Samples and Slide Deck
<< 1 >> 

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Universal calculated measures in MDX queries
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices