SQL Saturday Precon - SSIS Design Patterns

Location: Microsoft Auditorium, EPDC2, Leopardstown
Date: Friday, 23rd March, 2012
Time: Registration from 9.00. Class starts at 9.30
Cost: €199 Early bird till 1st March. Full Price €249

Delivered by Matt Masson, Software Development Engineer on the Microsoft SSIS Product Team. This course will be a don't miss for anyone heavily involved in designing or implementing SSIS solutions.

Register Now

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. Finally, we'll take a close look at the new features and functionality provided in SQL Server 2012.

If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!

Course Modules

  • 09:30 - Introduction
  • 09:45 - Module 1 - Data Flow Internals
  • 10:30 - Module 2 - Benchmarking and Performance Best Practices
  • 11:15 - Module 3 - Common Design Patterns
  • 11:00 - Break
  • 12:00 - Module 4 - Lookup Design Patterns
  • 12:45 - Break
  • 13:00 - Module 5 - Parallelization Design Patterns
  • 14:00 - Module 6 - Advanced Design Patterns
  • 14:45 - Break
  • 15:00 - Module 7 - SSIS in SQL Server 2012
  • 17:30 - Finish

Register Now


  • Matt Masson

    Matt Masson


    Matt Masson is a Software Development Engineer working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product including upgrade, performance, and overall user experience. He is a frequent presenter at Microsoft conferences, and maintains the SSIS Team blog http://blogs.msdn.com/b/mattm/).

    Prior to joining Microsoft in 2006, Matt was a developer on a number of BI Reporting and Analytical products. He currently lives in Montreal, Quebec, and works remotely with his Redmond-based team.


    Matt's blog URL is http://www.mattmasson.com/

Related Events


Other Information