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

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Mon, 12 Apr 2010 01:30:41 +0000 Indexed on 2010/04/12 4:23 UTC
Read the original article Hit count: 936

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: 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)


Filed under: Business Intelligence, Data Warehousing, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology Tagged: TechEd, TechEdIn

© SQL Authority or respective owner

Related posts about Business Intelligence

Related posts about Data Warehousing