THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Master Data Services Team

Blog for the Microsoft SQL Server Master Data Services (MDS) team. Blog posts are contributed by various team members.

Updated Master Data Services Documentation and Resources

(This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team)

With the release of SQL Server 2008 R2, it’s a great time to check out the updated documentation and resources for the release, and for SQL Server 2008 R2 Master Data Services ("MDS") in particular. As you saw in the last post (New White Papers Available), there are some great white papers available on MSDN to get you going with MDS. Below you’ll find more information about other updated and newly published content.

SQL Server 2008 R2 Books Online
The MDS product documentation was first published in SQL Server 2008 R2 Books Online with the November CTP (at the same time as the first public release of MDS in SQL Server 2008 R2). The MDS User Education (UE) team has been working on improving and adding a lot of additional content that was not available for the first release of the content. You can find the MDS portion of Books Online on both MSDN and TechNet at the following URLs:

With this documentation update, you’ll see the following improvements:

  • Overviews and workflows for getting started with MDS, installing and configuring MDS, and configuring security (in the Getting Started, Deployment, and Security and Protection nodes)
  • Better installation, configuration, and uninstall documentation (in the Deployment node)
  • Conceptual content with artwork tied to related procedural content (in the Operations node)
  • More comprehensive security documentation (in the Security and Protection node)
  • Updates to the technical reference to have more information about the staging tables and error messages (plus examples for importing data into those tables), Web configuration, and PowerShell cmdlets (in the Technical Reference node)
  • Troubleshooting documentation for installation and configuration, staging, model deployment, and notifications (links from the Troubleshooting node out to topics elsewhere in the doc set)

If you were familiar with the content before, you’ll notice that some things have moved around a bit in the Table of Contents (TOC), such as some topics being moved out of Getting Started into Operations and out of Planning and Architecture to Deployment. We hope that by moving related content closer together, you’ll find things easier to navigate and have a more comprehensive view.

Introducing Microsoft SQL Server 2008 R2
Microsoft Press has released a free e-book for download, Introducing Microsoft SQL Server 2008 R2, which has a chapter about MDS, as well as chapters about the other exciting features and enhancements for the release. The URL to download the book is

Enjoy the new content, and keep giving us feedback. We really appreciate it!

Published Wednesday, April 21, 2010 5:09 PM by MDS Team
Filed under: ,



Alexey Gudzera said:

Hello, MDSTeam!

I am trying to make some search functions for MDS by developing some WCF proxy service.

If possible, please, could you give some examples on using EntityMembersGetCriteria.SearchTerm together with mdq.Similarity function to provide some sort of fuzzy search on EntityMember name or another attribute?

Thanks in advance!

Sincerely yours, Alexey Gudzera.

April 22, 2010 5:17 AM

Alexey Gudzera said:

Well, I've got the idea! Sometimes it takes to use Reflector to realize that estimated syntax of SearchTerm is dumb!!!

Well, for everyone who wants to know how to use SearchTerm here goes an example:

  request.MembersGetCriteria.SearchTerm = String.Format(" [Name] MATCH '{0}' 0.5 1 0.32 ", searchRequest.MemberNameToSearchFor);


[Name] means name of the column to search in.

MATCH means mdq.Simplicity function

{0} is your string to search for

0.5 is minSimilarity which means minimum matching score of element to be returned

1 means method to use

0.32 means how exact method will be.        

April 22, 2010 9:47 AM
New Comments to this post are disabled
Privacy Statement