Learn more about SQL Server tools


Latest from MSSQLTips

Find Tables, Columns or Stored Procedures used in a SQL Server Reporting Services Report

Dynamically Refresh SQL Server Reporting Services Report Date Parameters

SQL Server 2016 T-SQL Syntax to Query Temporal Tables

Troubleshoot SQL Azure Bacpac Import Failures

On-Demand Webcast - Monitoring SQL Server with Mobile Devices

Configure the SQL Server Integration Services For Loop Container

On-Demand Webcast - Performance Monitoring with Uptime

On-Demand Webcast - Physical and Virtual Performance Monitoring with SQL Diagnostic Manager

On-Demand Webcast - Encrypting Data with SQL Server

On-Demand Webcast - Performance monitoring with Spotlight on SQL Server

Whitepaper - Resolving the Database Performance Blame Game

3 Tips for Managing Large Numbers of SQL Server Jobs

Accelerate SQL Server with Flash Storage

Introduction to Master Data Services in SQL Server 2008

MSSQLTips author Tim Cullen By:   |   Read Comments (2)   |   Related Tips: More > Master Data Services

>>> >> > Vote for your favorite MSSQLTips.com Authors < << <<<


So, between all of my company's recent growth and more acquisitions looming in the horizon, I feel like the company's data is getting out of hand. There are numerous databases housing the same information and it's getting quite difficult to keep everything in line. I've heard from a number of departments who want a more centralized approach to handling customer data, but I don't know where to begin. Can you steer me in the right direction?

You just ran into one of the biggest headaches for DBA's. If we've seen it once we've seen it a thousand times, data starts out in a spreadsheet in each department and then each department wants their own database. Then "it" happens, a client orders product and the order is shipped to the wrong location. The salesperson said he updated the shipping address in the database, but the Shipping Department shipped the product to an address from their database that hasn't been updated in months.


What we're talking about here is Master Data Management and there are a number of ways to handle it. Microsoft has a new answer to Master Data Management...Master Data Services, thanks to the acquisition of Stratature. Master Data Services will be released in SQL Server 2008 R2, but before we dive into the innards of Master Data Services, let's talk about the principles of Master Data Management.

What Is Master Data Management?

In simple terms, Master Data Management (MDM) is a process through which consistent, clean, up-to-date data is managed within an organization; however, "simple terms" does not mean "simple to implement". The fact of the matter is that Master Data Management is a process that starts out small and progresses as lessons are learned by the company. A number of factors are involved when evaluating data for consideration as "master data". It's probably easier to sift through your data and decide what isn't master data. One of the first steps in implementing a Master Data Management System is to decide that a Master Data Management process is actually needed!! In most cases the answer will be yes, but implementation of a MDM can be quite costly, both in terms of development as well as personnel hours, so it would be prudent to spend time justifying the need.

Who Should Be Involved With Implementation of a MDM?

Other than the DBA, personnel who understand the data and its sources should be involved in the planning and implementation process. They are considered data stewards. Other people include management and important stakeholders in the data, since there are financial and personnel considerations when developing and implementing a master data management program.

What Are the Important Buzzwords With Master Data Services?

Most of the "buzzwords" you'll hear when dealing with Master Data Services are used in other data modeling techniques:

So What's A Good Way to Get Started At Reviewing Our Data?

Perhaps the first place to look is for tables that are stored in multiple databases. Examples may include, but are not necessarily limited to, information on state and territories, zip codes, and domain-based information like colors, sizes, and contact types. The next bit of data to review could be the essential data required for identifying your customers, as well as the data required to get your products to clients, including contact names, company addresses, and phone numbers.

Are There Any Limitations For Installing and Using Microsoft's Master Data Services?

Before you get too excited about using Master Data Services there are some limitations for installing and using it. First, Master Data Services will only be available for SQL Server 2008 R2 DataCenter, Enterprise, and Developer editions. Second, it will only be available for x64 versions of SQL Server. Lastly, the minimum framework it requires is the .NET Framework 3.5 SP1.

Next Steps

Last Update: 6/4/2010

About the author
MSSQLTips author Tim Cullen
Tim Cullen has been working in the IT industry since 2003 and currently works as a SQL Server Reports Developer.

View all my tips
Related Resources

print tip Print  
Become a paid author

join MSSQLTips for free SQL Server tips     

Learn more about SQL Server tools

Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates

       Note: your email address is not published. Required fields are marked with an asterisk (*)

Get free SQL tips:

*Enter Code refresh code     

Tuesday, May 20, 2014 - 12:17:01 PM - Tim Cullen Read The Tip

Unfortunately it is only available in 2008 R2 and later.

Tuesday, May 20, 2014 - 11:41:38 AM - sajeev Read The Tip

Is MDS avaliable with SQL Server 2008 (NOT SQL 2008 R2). If it is avialbale how can i install MDS, is it seperate installation or it along with SQL Server set up?


Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.