SQL Server 2008 for Developers

Last year I noticed that several people in my area haven’t upgraded to SQL Server 2008.  This year I noticed several people were using SQL Server 2008 but didn’t know the new features for developers.  This motivated me to create the following presentation.

The following is the slide deck used for SQL Server 2008 for Developers presentation.   This includes demos from the SQL Server 2008 Developer Kit and also some custom developed demos.

Click here to download the slide deck.

The following topics are covered:

  • Management Studio (SSMS) Enhancements
  • T-SQL DelightersFiltered Indexes
  • New Date and Time Data Types
  • Filtered Indexes –  MSDN Link
  • Table-Valued Parameters
  • MERGE statement
  • CMS and Policy Based Management
  • Change Data Capture