SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2

What is MDS?

Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets company wide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time. (Source: Replace with Microsoft)

Today I will be talking about the same subject at Microsoft TechEd India. If you want to learn about how to standardize your data and apply the business rules to validate data you must attend my session. MDS is very interesting concept, I will cover super short but very interesting 10 quick slides about this subject. I will make sure in very first 20 mins, you will understand following topics

  • Introduction to Master Data Management
    • What is Master Data and Challenges
    • MDM Challenges and Advantage
  • Microsoft Master Data Services
    • Benefits and Key Features
    • Uses of MDS
    • Capabilities
  • Key Features of MDS

This slides decks will be followed by around 30 mins demo which will have story of entity, hierarchies, versions, security, consolidation and collection. I will be tell this story keeping business rules in center. We take one business rule which will be simple validation rule and will make it much more complex and yet very useful to product.

I will also demonstrate few real life scenario where I will be talking about MDS and its usage.

Do not miss this session. At the end of session there will be book awarded to best participant.

My session details:

Session: Master Data Services in Microsoft SQL Server 2008 R2
Date: April 12, 2010  Time: 2:30pm-3:30pm

SQL Server Master Data Services will ship with SQL Server 2008 R2 and will improve Microsoft’s platform appeal. This session provides an in depth demonstration of MDS features and highlights important usage scenarios. Master Data Services enables consistent decision making by allowing you to create, manage and propagate changes from single master view of your business entities. Also with MDS – Master Data-hub which is the vital component helps ensure reporting consistency across systems and deliver faster more accurate results across the enterprise. We will talk about establishing the basis for a centralized approach to defining, deploying, and managing master data in the enterprise.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

10 thoughts on “SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2

  1. Hi Pinal! First of all I would like to thank you for sharing your knowledge and ideas to the SQL server community. If possible could you please post your lectures (recorded webnor videos) on your blog, I know its a laborious task but your community will definitely appreciate it. Thanks again bye bye.


  2. Hi Pinal,

    I am beginner to sql server and i have small doubt abt the joins i,e if we join 10 tables internally what is gng on..

    i mean first dataset of 2 tables and join the 3rd table and…

    is this correct or not.my head is blowing out


  3. Hi Pinal,

    I am trying to find more information about the benefits and differentiators of Master Data Services versus competitors solution (VisionWare etc…)

    Would you have some information you could send me?

    Thank you


  4. Pingback: SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 24 of 31 Journey to SQLAuthority

  5. Hi Pinal,
    I am interested in viewing your session on “Master Data Services in Microsoft SQL Server 2008 R2”. Do you have recorded video on that. Please share link.

    Thanks a lot for sharing useful information.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s