PASS Database Days 2013

17th - 19th April 2013Trafo Conference Centre Baden, Switzerland

Swiss PASS Chapter

Data Curation: Effective ways to optimize your data with MDS & DQS

Tillman Eitelberg, Oliver Engels

(Principal Specialists, oh22Information Services)


Data Quality Services (DQS) and a new version of Master Data Services (MDS) were introduced with SQL Server 2012. It's an out of the box product for the Data Steward and the Information professional and can help to solve most of the data quality and master data issues in the enterprise.



This workshop gives you a complete overview on these new technologies in SQL Server based on a real world closed loop scenario. In the scenario we will show how SSIS, DQS, MDS and other SQL Technologies work together, you will learn concepts like DQS Domains, Rules and how to use Remote Data Services with Windows Azure marketplace. You learn how to use MDS Models, Entities and Hierarchies etc.



You will see MDS Staging concepts, SharePoint and Excel Integration and you learn how everything is connected in a closed loop. During the sessions you will see best practices, performance tips and tricks and maybe also stuff you would not do at home. At the end you have a full picture of DQS and MDS and an understanding where you can use it and how to optimize it. 



About the Speakers:

Tillman Eitelberg

 Oliver Engels 

Related videos