SSWUG.ORG Ultimate Virtual Conference – April 2009

Published Mar 25 2019 02:25 PM 82 Views
Not applicable
First published on MSDN on Mar 30, 2009

I flew to Tucson last week to record my sessions for the upcoming SSWUG.ORG Spring Virtual Conference . I recorded three sessions for the BI track :

How to Avoid Common Pitfalls with SSIS

Starting up a new project with SQL Server Integration Services? Save time and money by learning about how to avoid common issues that users hit when implementing their ETL solutions. Drawing on the most frequently asked questions in the MSDN Integration Services forum and some of the more interesting packages we've seen over the years, we'll highlight common mistakes, clear up some misconceptions, and provide best practices to help you efficiently and effectively use Integration Services.

Incremental Data Warehouse Loads with MERGE and Change Data Capture

This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. We'll cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you're interested in learning best practices for this new SQL Server 2008 functionality, you won't want to miss this session!

New Connectivity Options in SSIS 2008

Figuring out the best way to connect to your data sources can be tricky. SQL Server Integration Services 2008 has made it easier with the addition of new high performance connectors for Oracle, Teradata, and SAP BI. This talk will walk through their features, and take a look at how they can drastically improve the performance of your data loads.

They put together a very impressive list of speakers again (I’m still surprised – and honored – to see my name next to these people!), and the sessions look pretty good as well. I’m sure I’ll be attending a number of the sessions myself. Some of the other SSIS ones include:

Anthony D'Angelo - Deep Dive: Extending SSIS with .NET Development

Brian Knight - Dynamically Configuring SSIS packages, Loading a Data Warehouse in SSIS, Performance Tuning SSIS 2005 and 2008

John Welch - Doing More (ETL) with Less (Effort) by Automating SSIS, Processing Flat Files with SSIS

Ted Malone - Agile Business Intelligence - Proven Techniques that move BI Development into the Agile World

They still have an early bird registration rate going, and you can use the vip code SPVMMASP09 to get an additional discount. The conference runs from April 22-24th… hope to see you there!

Version history
Last update:
‎Mar 25 2019 02:25 PM
Updated by: