CITATION

Graham, Tyler and Selhorn, Suzanne. Microsoft SQL Server 2008 R2 Master Data Services. US: McGraw-Hill Osborne Media, 2011.

Microsoft SQL Server 2008 R2 Master Data Services

Published:  February 2011

eISBN: 9780071756242 0071756248 | ISBN: 9780071756235

Book description:

Best Practices for Deploying and Managing Master Data Services (MDS)

Effectively manage master data and drive better decision making across your enterprise with detailed instruction from two MDS experts. Microsoft SQL Server 2008 R2 Master Data Services Implementation & Administration shows you how to use MDS to centralize the management of key data within your organization. Find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules. Legacy system integration and security are also covered. Real-world programming examples illustrate the material presented in this comprehensive guide.

  • Create a process-agnostic solution for managing your business domains

  • Learn how to take advantage of the data modeling capabilities of MDS

  • Manage hierarchies and consolidations across your organization

  • Import data by using SQL Server Integration Services and T-SQL statements

  • Ensure data accuracy and completeness by using business rules and versioning

  • Employ role-based security at functional, object, and attribute levels

  • Design export views and publish data to subscribing systems

  • Use Web services to progrmmatically interact with your implementation

Tyler Graham

is a Senior Program Manager with the Microsoft Master Data Services team. Before joining Microsoft, he spent 10 years in the field working with organizations on data quality issues. Tyler frequently assists with major implementations at Fortune 500 companies.

Suzanne Selhorn is Technical Writer on the MDS team. She was a major contributor to the SQL Server 2008 R2 Books Online content for Master Data Services.