SQL Server 2008 Double Header

by sugadmin on April 10, 2008

Wednesday, May 14, 2008 at 6:00 PM

Mike and Mike from Ascentium will cover two of the most interesting and useful new features of SQL Server 2008: Change Data Capture and the new MERGE statement. If you live in BI or just want to learn the cool s%*t coming in the next version of SQL Server, come join us while we explore these new features.

The new Change Data Capture (CDC) feature in SQL Server 2008 captures all INSERT, UPDATE, and DELETE transactions to selected tables and columns. The details of the transactions are copied to a new “data capture” table in an easily consumed relational format. The first talk will provide an introduction to this new feature of SQL Server 2008 and a short lab to explore how it really works.

The second part of this talk covers the new MERGE statement. MERGE combines the features of the INSERT, UPDATE, and DELETE statements into one powerful statement. Now you can easily update, insert, and delete multiple rows of data with a single statement. We will explore the use of the MERGE statement with table values as input parameters in an interactive lab.

Duration: 60-90 minutes

Leave a Comment

Previous post:

Next post: