What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

What you will learn

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

What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

Microsoft SQL Server 2012 Performance Tuning Cookbook

$65.99

Microsoft SQL Server 2008 R2 Master Data Services

$60.99

Total $ 126.98

Customer reviews

Rating distribution

4.3

(4 Ratings)

5 star 25%

4 star 75%

3 star 0%

2 star 0%

1 star 0%

Nicholas Barclay Sep 08, 2011

This is just what I look for when I want to get up and running with a new product. Jeremy, Tim and Martyn have written a book for getting up to speed on just about every aspect of MDS. Experienced users can use the book to ensure existing knowledge gaps are filled and experiment with more advanced functionality.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. In this day and age publishers are focusing more on delivering content digitally. The layout of digital publications is often performed dynamically on devices such as the Kindle or iPad, as a result what is considered "a page" is not necessarily the same because each reader's personal settings may differ. Text referring to "the screenshot above" or "the previous page" may not necessarily be accurate or helpful. Which page? Which screenshot? Annoying. What is so difficult about "refer to Figure 1.2", or "as listed in Table 3.4"?All in all this is a book well worth getting hold of if you want to get stuck into all aspects of MDS from installation to advanced usage.

Amazon Verified review

Marius Zaharia Oct 06, 2011

[extract from my blog at [...]]I read recently a technical book - "Microsoft SQL Server 2008 R2 Master Data Services" (edited by Packt Publishing).For those not familiar with the Microsoft's homonymous product: Master Data Services - briefly named MDS from now - is the first step of Microsoft in the world of master data management. Coming from the earlier Stratature's acquisition, the product is the first generation of a new BI-related family formed around SQL Server 2008 R2 and which tends to add more value at the business level, together with other coming concepts in SQL Server Denali, like data quality services, "powerpoint" for data, and others.Now, as for the book's name, I have to say that having several books named around the product's name may become confusing and hard identifiable - so I may have chosen something a bit different; but let it be so, now.Having a pretty good knowledge of the product, I was curious how this book addressed a pretty narrow area - a niche one, I may say - knowing that it is difficult to choose the level you target in that case (expert - specialized/very small audience versus accessible-larger audience/boring/no added value). So first of all, it was pretty obvious that a decent database developer/specialist could easily start up on the knowledge of: master data management concepts; MDS overview; MDS installation and configuration; creating and using models etc. The tone "smoothly" changes when coming close to more specific concepts: version management, importing data and the staging process. I remarked that, for the ease of understanding, most of the tasks were explained from the eyes of a database guy - that is, what kind of DB operations are hidden behind the actions applied via the product's web UI (because, right, almost all engine and features are database-based, if I can say so).Where the things became really interesting was on the integration side. And I can tell you there is the one of the main tricks. Here's why: because in fact - even at this early stage of development - Master Data Services, while not exposing all the needed data integration features in an advanced mode, it still hides inside what Microsoft have done everywhere: integrating its various servers and technologies together and taking benefit from the dialog of all these structures. But - very few examples were available at that time - even I struggled a while and investigated a lot around the integration solutions we may have. And here is the surprise - from the book: *Input integration to the staging tables via SSIS (SQL Server Integration Services) *A large sub-chapter dedicated to the business rules workflow extension via SharePoint (a full project solution example) *Extracting data from MDS via subscription views and delivering master data via BizTalk Server (again, with sample databases, project/solution, schemas, map, ports etc.) *MDS Web Service API, data integration with SharePoint Web Parts, and, again, with SharePoint Workflow, this time on the way back to MDS for updating master data. I can tell you it is the only example I found until now of a full roundtrip between MDS and SharePoint workflow.What I found it's missing/could be better: *Some words about the deployment of a solution for Master data Services *A more detailed view on MDS security (the permissions propagation and deployment can be very tricky)With this, I found overall that it was a good occasion for me to start a series of technical book reviews - start with a good one :).

Amazon Verified review

Cooldudez Oct 13, 2011

This is my first book review in this year, though it is a good experience in writing my first book on SQL Server technologies and here it goes:Book Title: Microsoft SQL Server 2008 R2 Master Data ServicesPublishers: Packt PublishersMaster 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. As a DBA & Data Architect there are certain chapters that I recommend, second chapter that overviews MDS architecture, sixth chapter importing data into MDS which highlights process and population of data, eighth chapter extracting data from MDS in delivering master data and ninth chapter that overviews application programming interface. No matter the level of knowledge that you may have about Master Data Management, this book delves into the concepts, development and implementation of Master-Data solution in your organisation using Microsoft SQL Server technologies.The authors are experienced professionals from Adatis, a UK based specializing in Microsoft Business Intelligence stack. The write up in the book shades author's experience, Jeremy Kashel, an experienced Business Intelligence professional has written majority of the chapters. Also Tim Kent, a QA specialist and Martyn Bullerwell, a project delivery specialist has co-authored this book.Finally if you are looking for practical ways to learning about Master Data Management concepts and SQL Server Master Data Services then this book is a good resource for you. Also the experienced users this is a good resource for your book shelf for quick reference in delivering Business Intelligence based Master Data Services solutions.To obtain the paperback and eBook version review and purchase from Packt_Publishers for other great resource of books on SQL Server technologies, also from Amazon (US & UK) websites.

Amazon Verified review

Daniele Tosatto Aug 25, 2011

I spend many time on configuring and tuning SQL Server for best performance and reliability. This book give me the chance to know deeper Master Data Services: so thanks Packt Publishing for this opportunity.Authors, Jeremy Kashel, Tim Kent and Martyn Bullerwell, have over 10 years' experience in delivering SQL Server Business Intelligence proejcts and stack.The book starts introducing you what are Master Data Services (MDS),why MDS application is necessary and why it can be of benefit for an organization.It shows you how to install, configure and use MDS to centralize the management of key data within your organization: also, you can find out how to build an MDS model, establish hierarchies, govern data access, and enforce business rules.In short, it shows you the ideal path for taking your first steps with MDS giving you also an excellent coverage of Microsoft Sharepoint and BizTalk integration, security and API.This book is a good start about MDS if you are a newbie: ideally the book is written for the analyst or developer coming to MDS for first time.So,if you are looking for a book about MDS it is a good choice in my opinion: it is well-written and rich of examples (You can download example code files from Packt Publishing web sites) that guide you on create, manage and mantain your business master data.

Amazon Verified review

FAQs

What is the digital copy I get with my Print order?

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

Microsoft SQL Server 2008 R2 Master Data Services: Written by two leading Microsoft SQL Server specialists, this book will empower you to manage and maintain the data used for critical business decisions through an understanding of Master Data Services. A comprehensive, totally practical tutorial.

What do you get with Print?