Category Archives: MDS/MDM

Data Warehouse vs Master Data Managment

Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM).  Below is a good list of how they differ.  Note the typical scenario is the data in a MDM database is fed into … Continue reading

Posted in Data warehouse, MDS/MDM, SQLServerPedia Syndication | Leave a comment

Data cleansing in SSIS, DQS, and MDS

Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS).  The lines are a bit blurred when talking about data cleansing using SSIS, DQS and MDS.  In what product should data … Continue reading

Posted in DQS, MDS/MDM, SQLServerPedia Syndication, SSIS | 1 Comment

Profisee Master Data Maestro

I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months.  I also have been using Microsoft’s Data Quality Services (DQS) for the last couple of months.  While both products are very good and … Continue reading

Posted in DQS, MDS/MDM, SQLServerPedia Syndication | 2 Comments

Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides

Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting. Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS). Introduction to Microsoft’s Master Data Services (MDS) … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Introduction to Microsoft’s Master Data Services (MDS) Presentation

Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting.  Below is the abstract.  I will be presenting in person but you … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only to models that are deployed or created after SP1 is applied (models deployed or created before SP1 is applied are … Continue reading

Posted in MDS/MDM, SQLServerPedia Syndication | 1 Comment

Master Data Management (MDM) Hub Architecture

The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in the database and keep it synchronized with the transactional systems that use the master data.  There are three basic styles … Continue reading

Posted in MDS/MDM, SQLServerPedia Syndication | Leave a comment

MDS: The Microsoft SQL Server license has expired

When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU), you might see the message “The Microsoft SQL Server license has expired” when trying to pull up the MDS web … Continue reading

Posted in MDS/MDM, SQLServerPedia Syndication | 3 Comments

Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides

Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter.  The recording of the session is available here. Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS) I had some … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | 2 Comments

Introduction to Microsoft’s Master Data Services (MDS) Presentation

I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec 20th, at Noon CST.  Below is the abstract.  It will be a remote presentation that you can join online.  Details … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment