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

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)