Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

 

 

 

Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

 

 

 

 

 

 

On May 31st, 2013, Microsoft Canada will host Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS. This half day event that will feature Matt Mason, Senior Program Manager from with the SQL Server Integration Services (SSIS) team.

Spots are limited! Don’t miss a chance to meet Matt Masson,  Matt has worked on many aspects of the SSIS product, and has written two books for SQL Server 2012 – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press). He is a frequent presenter at SQL conferences, and blogs at https://mattmasson.com/.

 

Email us now to confirm your space for this event using the link below.

Date: May 31, 2013

Location:

Microsoft, 1950 Meadowvale Blvd.

Mississauga, ON L5N 8L9

View the map

 

Agenda:

   

What’s New in SSIS 2012 

9:00am – 10:00 am

This demo-intensive whirlwind tour will show off the new features and functionality in SQL Server Integration Services (SSIS) for SQL Server 2012. From the productivity enhancements in the designer, to the new SSIS server deployment model, there’s something in the release for everyone. If you haven’t seen SSIS in SQL Server 2012 yet, you won’t want to miss this session!

EIM - Bringing Together SSIS, DQS, and MDS 

10:00am – 11:15am

Enterprise Information Management (EIM) is an industry term for managing your data for integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.

Break

 11:15am – 11:45am

 

SSIS Performance Design Patterns

 11:45am – 1:00pm

 

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We’ll start off by looking at how to set performance expectations, and see how you can easily put together a simple framework to record benchmarks for your ETL process. We’ll then dive into a number of common design patterns, such as surrogate key generation, advanced Lookup patterns, parallel processing, change data capture, and different ways of handling slowly changing dimensions.

Presenter:

 

 Matt Masson

 Matt Masson is a Senior Program Manager working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product, and has   written two book for SQL Server 2012 – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press). He is a frequent presenter at SQL conferences, and blogs at https://mattmasson.com/ . He currently lives in Montreal, Quebec, and works remotely with his Redmond-based team.