- Paperback: 384 pages
- Publisher: McGraw-Hill Education; 1 edition (March 17, 2011)
- Language: English
- ISBN-10: 007175623X
- ISBN-13: 978-0071756235
- Product Dimensions: 7.3 x 0.8 x 9.1 inches
- Shipping Weight: 1 pounds (View shipping rates and policies)
- Average Customer Review: 10 customer reviews
- Amazon Best Sellers Rank: #2,945,196 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft SQL Server 2008 R2 Master Data Services 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
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.
Top customer reviews
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.
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.
All the supplemental thoughts aside, I give this book 5 stars and highly recommend it. If the authors had addressed all of these topics in the book, the book would have been a couple of thousand pages easily negating its values. This is probably the best introductory book on data governance that I've seen.
I'd recommend reading it to not only understand how to use Microsoft's SQL Server 2008 R2 tool, but understanding that more information will be needed to successfully implement this on an Enterprise, Production-ready level.
It starts out with an introduction to Master Data Services and then jumps right into installation and configuration.
You then create an MDS Project and add a new Model to it by hand. The book does a great job of providing step by step instructions. As I went through the book I didn't get the feeling I was lost. The authors do a good job of keeping you moving forward at the right pace.
The book has chapters on Starting an MDS Project, Creating Your Model, Integrating Master Data Services with Other Systems, Working with Hierarchies and Collection, Working with Master Data, Using Business Rules, Creating Versions of Data, Using Metadata, Implementing Security, Publishing Data to External Systems, and Extending MDS with Web Services.
I cannot recommend using the current Microsoft MDM tools to anyone, but it can't hurt to start learning them now. The Microsoft MDM tools are showing signs of improvement with Denali, but they still have a way to go before the product is a competitor to products like the IBM MDM stack.
I can however recommend this book as a great resource for learning all about the current Microsoft MDM tools. The tools are not that straight forward to learn and this book does a great job of neutralizing the confusion and teaching you the ins and outs of the MDS tools offered by Microsoft in SQL Server 2008 R2.
The authors provide a nice download that contains a sample model package, sample data in CVS files and a visual studio solution that wraps the MDS web service.
All in all I highly recommend this book to anyone looking to get up to speed quickly with the Microsoft MDS tools.
Most recent customer reviews
It seems like the writers have a deep understanding of the MDM space in general and deep insights into the Master Data...Read more