Microsoft SQL Server 2008 R2 Master Data Services

More Information
  • Understand the foundational concepts of Master Data Management and SQL Server
  • Learn how to install and configure Master Data Services
  • Create and populate your first Model
  • Learn how to create and manage Hierarchies and Collections
  • Extend your Models with User-defined Meta Data
  • Control your Master Data Environment through the use of Versions and Flags
  • Discover how to import data from a variety of source systems by using SQL Server Integration Services (SSIS)
  • Extend your solution with business rules, e-mail notifications, and SharePoint workflow
  • Create custom solutions by utilizing the Master Data Services API
  • Feed different source systems by using Subscription Views and BizTalk Server
  • Secure your Master Data Services Models with comprehensive MDS security

Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data.

A focused, practical tutorial, this book will show you how to manage and maintain your organization's master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.

This book will enable you to manage and maintain your organization's master data with Microsoft SQL Server 2008 R2 Master Data Services, covering each feature in a step-by-step manner. The book starts with an overview of Master Data Management. You will then move on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS). The book then dives deep into topics such as installing, configuring, and maintaining Master Data Services, creating and using Models, Version Management, Business Rules, and importing Data into Master Data Services amongst others.

  • Gain a comprehensive guide to Microsoft SQL Server R2 Master Data Services (MDS) with this book and eBook
  • Explains the background to the practice of Master Data Management and how it can help organizations
  • Introduces Master Data Services, and provides a step-by-step installation guide
  • Covers all features of Master Data Services, including hierarchy management, importing/exporting data, the MDS API, and business rules
  • Includes practical examples that guide the reader on how to use each feature of the product
Page Count 360
Course Length 10 hours 48 minutes
ISBN 9781849680509
Date Of Publication 18 Jul 2011


Jeremy Kashel

Jeremy Kashel is a Principal Consultant with Adatis, a UK-based Microsoft Gold Partner, specializing in the Microsoft Business Intelligence stack. Jeremy has over 10 years of experience in working with SQL Server business intelligence projects, for a variety of UK and international clients. Jeremy is also a keen blogger, and has spoken at a number of Microsoft events.

Tim Kent

Tim Kent is one of the owners of Adatis, and is also involved in project delivery and QA for the Microsoft Business Intelligence stack. Tim was first awarded the MVP for SQL Server in 2009, and has been specializing in SQL Server and the Microsoft BI stack for over 10 years. Tim is also an active member of the SQL Bits SQL Server conference organizing committee, and has also been involved in speaking at the event.

Martyn Bullerwell

Martyn Bullerwell is one of the owners of Adatis, and is involved in project delivery for Adatis' larger clients, including multi-terabyte data warehouses. Martyn has led projects in a number of different clients and sectors, including media, oil and gas, and banking.