SQL Saturday Precon#3 -
A Day of Enterprise Information Management - SSIS, MDS and DQS

Location: Microsoft Auditorium, EPDC2, Leopardstown
Date: Friday, 21st June, 2013
Time: Registration from 9.00. Class starts at 9.30
Cost: €199 Early bird till 31st May. Full Price €249

This session is recommended for ETL developers and DBAs who have previous experience with SSIS, and a basic understanding of data warehousing concepts. While some of the design patterns will also apply to SQL Server 2008 R2, this bulk of the session will focus on capabilities available in SQL Server 2012.

Enterprise Information Management (EIM) is an industry term for technologies to manage your data for integration, quality, and governance. This full day training session will show you how Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS) work together to provide a comprehensive EIM solution in SQL Server 2012. Focusing on Data Warehousing scenarios, we'll explore the key steps needed to build such a solution, from the beginning (planning, benchmarking), to data curation (cleansing, matching, managing dimensions), to data loading using SSIS. We'll also touch on some advanced data warehousing ETL design patterns, such as change data capture (CDC), slowly changing dimension processing, and automation.

Course Modules

  • Data cleansing and matching
  • Reference data managemen
  • SSIS design patterns
  • Incremental data loading
  • SSIS deployment, management, and monitoring
  • Automation

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