Ann Arbor Computer Society



AACS meets the first Wednesday of every month at SRT Solutions in Ann Arbor. The meetings start at 6 pm and typically last between 2 to 3 hours. Free pizza, salad, and soda is provided. SRT Solutions is located at 206 S. Fifth Avenue, Suite 200 Ann Arbor, MI 48104. All meetings are free, however if you enjoyed the presentation we do encourage making a $20 contributing membership. This membership fee allows us to continue to provide free refreshments and raffle prizes. To be notified of future meetings and job postings please join our mailing list here.

Next Meeting


SQL 2005/8 T-SQL:
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.