THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Matt Masson to Deliver an SSIS Precon at SQLBits 9!

My friend Matt Masson is also presenting a SQLBits 9 precon! Cross-posted from Matt’s blog:

SSIS Performance Design Patterns with Matt Masson

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? By selecting the right design, 90% of SSIS customers will achieve their ETL performance goals with little to no performance tuning. This session will teach you how to pick that design! Targeted at intermediate to advanced SSIS users, Matt Masson - a developer on the SSIS team - will guide you through a series of proven SSIS design patterns, and teach you how to apply them to solve many common ETL problems. We’ll start off with an overview of the Data Flow internals, and review the SQLCAT team’s Top Ten Best Practices for achieving optimal performance. We’ll then dive into a series of design patterns, including Advanced Lookup Patterns, Parallel Processing, Avoiding Transactions, handling Late Arriving Facts and multiple ways to process Slowly Changing Dimensions. If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!

Training Summary

09:30 Data Flow Internals + Benchmarking

10:30 -- Break --

10:45 Performance Best Practices

12:00 -- Lunch –

13:15 Common Patterns

14:00 Lookup Patterns

14:45 -- Break –

15:00 Parallelization Patterns

16:00 -- Break –

16:15 Advanced Patterns

17:00 -- End --

You can see the full list of all day sessions here, and booking information here.

Hope to see you there!

Published Wednesday, July 6, 2011 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement