Affiliations

facilities provided by


food/drink delivered by Domino's Pizza

Recent site activity

SQL 2005/8 T-SQL:

posted Oct 14, 2009 11:16 PM by Michael Gibbs   [ updated Mar 14, 2010 8:04 AM by Chris Sellers ]
New Features

with Phil Hun
----
 SPECIAL: Board Member Elections 

  Wednesday, March 3rd, 2010 @ 6pm

Abstract:
Phil plans to talk about the new features of SQL Server 2005 including:
  • Try/Catch
  • VarChar(MAX)
  • Top Variable
  • Table Value Functions (TVF)
  • Cross Apply (TVF)
  • Cross Apply
  • Outer Apply
  • Common Table Expressions (CTE)
  • Rankings - Row Number
  • Rankings - Dense / Rank / NTile
  • XML Support
  • C# / VB.Net Support (SQL/CLR)

and in 2008
  • Table Value Parameters (TVP)
  • Spatial.


Bio:
Phil has been a programmer for more than 25 years.  He first started working with SQL with Informix in 1988, and with SQL Server in 1998 on a Y2K project. At U of M, he worked on a project that lead to his first AACS talk on Data Transformation Service.   He later worked on the M-Reports project which lead to his Business Intelligence talk in November.  This talk comes from a recent book purchase at Borders.