SQL Server 2008 brings new capabilities that can be used to enhance the features and performance of your programs.  This presentation will show how to make use of new features in SQL Server:

• Table Valued Parameters for passing tables as a single parameter.
• MERGE statement that combines INSERTs, UPDATEs and DELETEs
• FILESTREAM capability to store large objects in the server’s file system.
• Enhanced Date and Time data types
• A new HierarchyID data type
• Large User-Defined Types
• Multi-parameter User-Defined Aggregates

Learn how to incorporate these new features in your programs.  Examples in C# and VB.Net.

Download will be available shortly before the first presentation on February 28th, 2009.

Andrew Novick is a developer/consultant with 25 years in the computer industry and a focus on SQL Server and Microsoft .Net.  His practice includes designing databases, query optimization, analysis of performance problems, and building business applications.  His writings include the books Transact-SQL User-Defined Functions and “SQL Server 2000 XML Distilled.  You can find additional articles on his web site: http://www.NovickSoftware.com