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 email address or mobile phone number.
Microsoft SQL Server 2008 R2 Master Data Services Paperback – July 19, 2011
|New from||Used from|
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Viewed This Item Also Viewed
About the Author
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 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 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.
Top Customer Reviews
I'm a big fan of technical books like this one: Explain the concept, take the reader through step-by-step instructions, build on what has been created in previous examples. By the time the reader has finished the book they have created a set of interrelated artifacts and performed tasks that touch almost all the major functional areas of the product.
The authors didn't stop at the basic functionality of MDS, a significant portion of the book is dedicated to the more advanced aspects of the product. T-SQL / SSIS based data loads, integration with SharePoint workflows, BizTalk and the MDS API are all covered. Lots of useful sample code and reference material earns the book a place on the within-easy-reach shelf.
Kudos to the authors for not making the book too heavy on the process rigor of master data management. They are careful to keep focus on setup, usage and extensibility of the product on which the book is based. Extra credit must also be given in that they managed to make the UI look simple and intuitive; the MDS web UI must be one of the clunkiest and difficult-to-use that I have had the displeasure to work with. The book makes it look easy. Hopefully MS is addressing this large shortfall in what is otherwise a pretty solid V1 product.
My primary criticism is directed at the book's publisher, not its authors. Packt's layout formula does not recognize the importance of reference numbers and caption text beneath screenshots, tables and figures.Read more ›
Book Title: Microsoft SQL Server 2008 R2 Master Data Services
Publishers: Packt Publishers
Master Data Services (MDS) is one of the new features that are introduced in SQL Server 2008 R2 version, and Master Data Management (MDM) concept which is also one of the new learning for me when I started working on data platform related projects.
Whenever you start reading a technical content book the first task is to check the table of contents and check what you will learn from the book. SQL Server 2008 R2 Master Data Services book suited for the users, professionals, business and systems analyst or DBA who wants to manage and maintain your business master data and improves data quality. This book is a comprehensive guide to MDS to facilitate end-to-end approach showing how to implement MDM on your data platform. The pragmatic approach and explanation from the authors emphasises the need of MDM which is an ideal methodology for analysts and developers.
The book helps the professionals who are looking to understand the MDM concepts to develop the Master Data Services feature. Not only have the technical aspects around MDS, the book covered business rules and workflows that can be created within MDS that are dependent on various conditions that can help to make a flexible MDS solution on your data platform.
The chapters are lined up systematically that introduces the need of Master Data Management (MDM) with a good example on Analytical MDM and Operational MDM.Read more ›
What MDS allows is a more top down approach, as covered in chapter 4, for example. Here, you can construct an entire object model hierarchy, where these derive naturally from the real world business context you have to deal with. From doing a top down set of models, the book shows how the user interface lets you rapidly commit this to a functioning database. The given example is worth contemplating for how it intuitively focuses on the business aspects.
Versioning is another big idea in the book. But it differs slightly from the word of the same name as used by programmers. For the latter, versioning is often used to freeze code at different times, and to debug and validate specific versions. To some extent this is also used here. But chapter 5 advises that version management can help you test different business scenarios, by maintaining independent copies of master data. Be careful about this. In more general programming environments, this can lead to awful problems later on, if you want to consolidate [ie. merge] 2 versions, whose data sets and rulesets built atop those data have deliberately diverged. Here's the thing. Most of chapter 5 deals with the details of how to make the versions. Low level instructions that you will certainly need. The problem can arise at the higher level of management of the project. Be careful about how much you want to do with split off versions. How is a lesser issue.
Most Recent Customer Reviews
[extract from my blog at [...]]
I read recently a technical book - "Microsoft SQL Server 2008 R2 Master Data Services" (edited by Packt Publishing). Read more
This is the time to start learning about Microsoft's Master Data Services and this book is a great place to start. Read morePublished on September 12, 2011 by T Anderson