Introduction to Microsoft SQL Server 2012 Master Data Services and Data Quality Services
This session introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS). MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation, and easier data updates and management. Additionally, a new staging interface supports loading data into MDS, while the new subscription views simplify the retrieval of data stored in MDS. DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data. Theory and demonstrations will introduce both services and will include the integration of the two in the MDS Excel add-in.