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

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 a 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 the 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

SQL SERVER - What is MDS? - Master Data Services in Microsoft SQL Server mds

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

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

Do not miss this session. At the end of the session, there will be a book awarded to the 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 a 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 (https://blog.sqlauthority.com)

Business Intelligence, Data Warehousing, MDS, MVP, SQL Server, SQLAuthority Author Visit, TechEd, TechEdIn
Previous Post
SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion
Next Post
SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005

Related Posts

9 Comments. Leave new

  • let us know the venue details.

    Rajesh varma

  • Hi Pinal,
    Where i can i find more details about master data services, is it about building a better architecture ETL/Data warehouses.

    Thank you

  • 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.

  • 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

  • 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

  • Thanks Pinal For your Knowledge Sharing ..
    I am regular reader of your Blogs .

  • Truly great blog, Dave.

  • 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.


  • Great blog, Dave, thanks


Leave a Reply