Microsoft SQL Server 2008 R2 Master Data Services and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Start reading Microsoft SQL Server 2008 R2 Master Data Services on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server 2008 R2 Master Data Services [Paperback]

Tyler Graham , Suzanne Selhorn
4.2 out of 5 stars  See all reviews (9 customer reviews)

List Price: $50.00
Price: $31.49 & FREE Shipping on orders over $35. Details
You Save: $18.51 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it tomorrow, July 15? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $29.92  
Paperback $31.49  
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now
There is a newer edition of this item:
Microsoft SQL Server 2012 Master Data Services 2/E Microsoft SQL Server 2012 Master Data Services 2/E 4.0 out of 5 stars (6)
In Stock.

Book Description

February 24, 2011 007175623X 978-0071756235 1

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

Frequently Bought Together

Microsoft SQL Server 2008 R2 Master Data Services + Microsoft SQL Server 2012 Master Data Services 2/E
Price for both: $66.30

Buy the selected items together

Editorial Reviews

About the Author

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.

Product Details

  • Paperback: 384 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (February 24, 2011)
  • Language: English
  • ISBN-10: 007175623X
  • ISBN-13: 978-0071756235
  • Product Dimensions: 0.7 x 7.4 x 9.1 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,234,191 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.2 out of 5 stars
4.2 out of 5 stars
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
4.0 out of 5 stars The must starting point to Master Data Services March 29, 2011
Being around Master Data Services - and master data management generally speaking - for more than a year, I was looking with interest to this book. It is rather a niche domain, so any investment in a dedicated documentation may be very valuable.

"Microsoft SQL Server 2008 R2 Master Data Services" is dedicated to the average user of the product as much as to the initiation in the master data management concepts.
The book - written by, probably, the best references in the field from the Microsoft team - takes a systematical approach of passing by all the necessary steps to mount a complete master data management system based on Microsoft Master Data Services. You will pass through product installation/configuration, project initiation, creating the model structure, integrating with and publishing to other systems, working with hierarchies & collections, mastering specific concepts like versioning, transactions, annotations, simple & advanced business rules; working with and extending metadata; implementing advanced security configuration, and so on. On every step when applicable, a parallel is made between the user interface manipulation and the equivalent web service API code.
While it exposes in structured way the already existing information from MSDN, the book adds value by using an example based approach - a fictive clothing company - which gives concreteness and understanding to the various concepts.

What I liked:
The systematical approach - if you pass through the whole book, you will have a complete overall understanding of the master data management, as much as of Master Data Services product itself.
Read more ›
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
Format:Paperback|Verified Purchase
I originally wanted to write this quite a while and am just writing it now.

My Perspective: I'm a Microsoft Certified Trainer and a BI Architect. I've had the experience of teaching many students Business Intelligence and of having architected solutions for Fortune 500 companies.

My thoughts...

This is one of the most well-written introductory books that I've seen. The exercises actually work on a virtual machine, which is always a plus. In addition, many complicated topics are simplified and presented in an introductory manner.

That said, the biggest advantage -- the ease and simplicity -- is also the biggest disadvantage.

To properly implement Master Data Services in an Enterprise scenario, one needs to have a full understanding of the theory within data governance. Otherwise, they will not be able to handle the complicated scenarios within an Enterprise. To properly understand data governance three holes need to be addressed, I recommend reading these books to address those holes in addition to this book:

1. Beginning Database Design: From Novice to Professional by Clare Churcher

2. MASTER DATA MANAGEMENT AND DATA GOVERNANCE by Alex Berson. --> Provides a deeper understanding of Data Governance Theory that is vendor neutral. This will be needed to understand any data governance solution.

3. Building a Data Warehouse: With Examples in SQL Server Vincent Rainardi --> Best and only book out there on building a data warehouse -- author supplements with some basic ETL theory on Data Warehouse Design, including the ETL. While the ETL isn't the newest out there, the theory on how to build ETL for a data warehouse is what is important. The ETL section was the weakest in this book.
Read more ›
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
Master Data Management, MDM, is a very broad topic. At a high-level, it entails managing data and metadata across multiple sources, throughout the data and business modeling process, through the Extract-Transform-Load (ETL) process(es) and into the Reporting layers. Many vendors tout their end-to-end MDM products. To get full benefit, a business typically has to purchase not only the vendor's MDM integration solution, but also their Data Modeling tool, their ETL Tool as well as their Reporting tool. Enterprise MDM solutions become very expensive, very quickly. Most businesses have an assortment of tools that frequently do not integrate easily without significant manual intervention.
Microsoft SQLServer 2008 R2 Master Data Services is Microsoft's solution to the integration nightmare confronting companies. This book is an excellent guide to getting up and running with the Master Data Services component of SQL Server 2008 R2. There are many screen-by-screen examples on setting up the application, configuring hierarchies, importing data model definitions. The primary users interact with Master Data Services via a web browser interface.
A word of caution, the tool, Master Data Services, requires a non-developer version of SQL Server 2008 R2 as a backend and the application itself can only run on a 64 bit machine running either Windows Server 2008 or later, Windows Vista Business or higher, or Windows 7 Professional or higher. Often companies that have Microsoft SQL Server will have a test server available that can be used to try it out, but the average home user will probably not have the spare server. I skimmed the setup and configuration sections which seemed easy to understand and very straight forward.
Read more ›
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Microsoft SQL Server 2008 R2 Master Data Services at Profisee
This is an excellent book, and a great way to learn about SQL Server 2008 R2 alongside other education materials such as Profisee's Master Data University, as the two go hand in... Read more
Published on February 13, 2012 by matthewmilad
5.0 out of 5 stars Very Hands on Learning
This is a very hands on book. It walks you through using every aspect of the current MDS tools.

It starts out with an introduction to Master Data Services and then jumps... Read more
Published on August 29, 2011 by T. Anderson
4.0 out of 5 stars You get the MDS construction
A very functional book to read as an introduction to MS Master Data Services. You're well up and running after having red this book. Read more
Published on April 4, 2011 by Magnus Wernersson
1.0 out of 5 stars Disappointment
I have really expected much more from this book considering authors experience and position. Instead of some conceptual knowledge I got only expanded version of BOL. Read more
Published on March 27, 2011 by Ognjen
5.0 out of 5 stars The best book about Master Data Services
The book is very well written and very easy to read.
It seems like the writers have a deep understanding of the MDM space in general and deep insights into the Master Data... Read more
Published on March 16, 2011 by Yair
5.0 out of 5 stars great!

I work on Master data services for more than 8 months, and this book is a very rich source of information, examples, explanations, it's very usefull!
great! Read more
Published on March 8, 2011 by xavave
Search Customer Reviews
Search these reviews only

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category