Mds and dqs
Download
1 / 13

MDS and DQS - PowerPoint PPT Presentation


  • 42 Views
  • Uploaded on

MDS and DQS. Beyond the TLAs to Data Quality. Neil Hambly – Northdoor PLC SQL Server Technology Evangelist. Who Am I ?. SQL Server Technology Evangelist for Northdoor PLC [email protected] DBA – 15+ Years, SQL Server 6.5 - 2014

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' MDS and DQS' - shaeleigh-fuller


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Mds and dqs

MDS and DQS

Beyond the TLAs to Data Quality

  • Neil Hambly – Northdoor PLC

  • SQL Server Technology Evangelist


Who am i
Who Am I ?

  • SQL Server Technology Evangelist for Northdoor PLC

    • [email protected]

    • DBA – 15+ Years, SQL Server 6.5 - 2014

  • Held # of DB roles @ many leading organizations

  • Regular International PASS Presenter @

  • SQL Conferences, User-Groups & Webinars

  • SQL London PASS Chapter Leader,

  • SQL Relay UK Events Organizer

  • PASS Professional Development VC Leader

  • Twitter: @Neil_HamblyContributing Author

  • Blog: http://dataidol.com/neilhambly/


Session agenda mds and dqs beyond the tlas to data quality
Session Agenda MDS and DQS - Beyond the TLAs to Data Quality

“Data Quality”

DQS Overview

  • Knowledge Bases, Industry Reference Data

  • DQS Tools

    EIM Solution {SSIS, DQS, MDS}

    MDS Overview

  • MDS Excel Add-in








Sql server cu1 improvements
SQL Server CU1 Improvements

Below are the comparative DQS performance numbers between the SQL Server 2012 RTM and CU1 releases: 


To upgrade a previously configured dqs server instance
To upgrade a previously configured DQS server instance

This chart helps to show which product updates require schema upgrades as well as Upgrade Dlls when schema upgrades are not required. 


Thank you

Thank you!

Diamond Sponsor


Mds training links
MDS Training {links}

Some new self-paced training is now available on the Microsoft Download Center.

To take advantage of this training, you should have a working installation of MDS with sample data already loaded.

01 Introductionhttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/01 Introduction.pdfThis lesson provides an overview of MDS.

02 MDS Environmenthttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/02 MDS Environment.pdfThis lesson provides an overview of MDS terminology and features of the Master Data Manager web application.

03 Managing Entitieshttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/03 Managing Entities.pdfIn this lesson, MDS terminology is explored in more depth. You start working with data and learn how to use the Master Data Manager web application to do common tasks.

04 Managing Hierarchieshttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/04 Managing Hierarchies.pdfThis lesson provides information about all of the available hierarchy types in MDS. You practice adding, removing, and moving members in hierarchies.

05 Creating Collectionshttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/05 Creating Collections.pdfThis lesson shows you how to create collections, and how to add and remove items from a collection.

06 Version Managementhttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/06 Version Management.pdfThis lesson explains version management and shows you how to view and reverse transactions.

07 Modeling Guidelineshttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/07 Modeling Guidelines.pdfThis lesson gives you ideas for how to use MDS to model your organization's data. It prepares you for the next lesson, where you will use the knowledge you've gained to start creating your model.

08 Model Buildinghttp://download.microsoft.com/download/5/9/F/59F1639E-EF57-4915-8848-EF1DC2157EBB/08 Model Building.pdfIn this lesson, you will use the knowledge from Lesson 07 to begin creating a model for your data.


ad