• Home
  • Microsoft SQL Server 2012
    • Latest Release Info
  • Microsoft SQL Server 2008 R2
    • Latest Release Info
    • Collection Weights
  • Resources
    • General Resources
    • Feature Resources
  • Master Data University
  • Contact
If you have started working with Master Data Services, you should use SQL Server Books Online. In the Operations node of the table of contents, you will find the bulk of the content. If you are looking for a start-to-finish list of many of the things you might want to do in MDS, see the Master Data Services Overview topic.

Here are other resources that relate to specific areas of MDS.
(This list is a work in progress. We are always looking for content created by real every-day MDS users, so let us know if you have something you would like to add.)

Installation

Installing and Configuring Master Data Services (SQL Server Books online)
http://social.msdn.microsoft.com/Forums/en-US/sqlmds/threads
MAKE SURE you enable the Windows Features and Roles before you start using Config Manager. (Whenever I start with a new VM I seem to forget this...)

Article with screen shots:
http://www.sql-server-performance.com/articles/dba/master_data_services_mds_overview_p1.aspx

Installation Troubleshooting (SQL Server Books online)
http://msdn.microsoft.com/en-us/library/ff487039.aspx

Staging (Loading Data into MDS)

Staging Examples and Troubleshooting (from the MDS team blog)
http://sqlblog.com/blogs/mds_team/archive/2010/02/10/staging-examples.aspx

More staging examples:
http://nickbarclay.blogspot.com/2009/11/beginning-mds-loading-members.html
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69372/

Using MDS to Map Multiple Systems

http://mattbi.spaces.live.com/blog/cns!9EE4FA43D304E745!276.entry
http://social.technet.microsoft.com/wiki/contents/articles/mapping-multiple-systems-with-master-data-services.aspx

Business Rules

Some detailed info about the notification interval (thanks to Jeremy Kashel)
http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2011/01/12/master-data-services-business-rules-and-the-notification-interval.aspx

Business rule info on the MDS team blog:
http://sqlblog.com/blogs/mds_team/archive/tags/Business+Rules/default.aspx

Web Services (Accessing MDS Programmatically)

People are always asking for help writing code. In the book we attempt to get you started. Other people out there have done some great things and I hope they help you too.

All of the code samples are here 
www.mdsmodeler.com 

Getting started with the web API (MDS team blog)
http://sqlblog.com/blogs/mds_team/archive/2010/01/12/getting-started-with-the-web-services-api-in-sql-server-2008-r2-master-data-services.aspx

Code to deploy models programmatically
http://sqlblog.com/blogs/mds_team/archive/2010/05/12/new-samples-on-msdn-code-gallery.aspx
(Scroll down to Model Deployment API code sample)

Using fuzzy match functions
http://blog.hoegaerden.be/2011/02/05/finding-similar-strings-with-fuzzy-logic-functions-built-into-mds/

Other samples and utilities
http://mdsmanager.codeplex.com/
http://mdsutilities.codeplex.com/

Subscription Views

More info, thanks to Jeremy Kashel
http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2010/09/26/master-data-services-subscription-views.aspx

General Troubleshooting

Troubleshooting Master Data Services Database Restore
Troubleshooting the Staging Process
Troubleshooting Model Deployment, Email Notifications, and Security:  http://msdn.microsoft.com/en-us/library/ff486963.aspx

Workflow

Whitepaper: SharePoint Workflow Integration with Master Data Services
http://msdn.microsoft.com/en-us/library/ff459274%28SQL.100%29.aspx

Extending SQL 2008 R2 Master Data Services (MDS) with IWorkflowTypeExtender
http://blogs.msdn.com/b/scicoria/archive/2010/11/14/extending-sql-2008-r2-master-data-services-mds-with-iworkflowtypeextender.aspx
Powered by Create your own unique website with customizable templates.