Reserved Words

People often ask about which words are reserved—which words they shouldn’t use when creating model objects. Here is a list of words you should not use for model objects (i.e., for your model, entity, and attribute names, as well as for business rules, subscription views, version flags, etc.). Model object reserved words ID LastChgVersionID Code… Read more

Downloading and Installing SQL Server 2008 R2 Master Data Services (MDS) Cumulative Updates

(This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team) Recently, we released the first cumulative update (CU) for Master Data Services (MDS). This blog entry explains how to download and install that CU, as well as subsequent CUs for MDS. Each Master Data Services (MDS) cumulative update is released as… Read more

New Resource for Master Data Services Information

(This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team) We’ve launched a new Web page on MSDN to consolidate information about Master Data Services (MDS) from many different sources: http://msdn.microsoft.com/en-us/sqlserver/ff943581.aspx. It is a portal to refer to, whether you’re just starting with MDS or are already implementing MDS in an… Read more

Creating Web sites and applications in Master Data Services Configuration Manager

(This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team) Lately, I’ve been seeing some confusion about creating and configuring the Master Data Manager Web application in Master Data Services (MDS) Configuration Manager. In this blog entry, I’m going to walk through the process in a bit more depth to help… Read more

Recorded MDS Presentations Available at Tech-Ed Online

We had great interest for our MDS presentations at the 2010 Tech-Ed / BI North America Conferences.  Thanks to all who attended.  If you didn’t get a chance to attend the MDS sessions, you can view the recorded presentations at Tech-Ed Online.   Introducing Microsoft SQL Server 2008 R2 Master Data Services [BIE203] This session introduces… Read more

Master Data Services first cumulative update is now available!

We have assembled a new release that addresses a number (30+) of issues that we could not address before the SQL Server 2008 R2 RTM release.  Everyone who is seriously considering Master Data Services or even kicking the tires is encouraged to take this update.  Anyone actively using the product is encouraged to take this… Read more

New Samples on MSDN Code Gallery

(This post was contributed by John Burrows, Lead Program Manager for the MDS Team) A couple of new samples have been posted to the MSDN Code Gallery; two sample models that illustrate recursive and explicit cap hierarchies and a Visual Studio solution that contains an example of calling the Model Deployment API via code. Sample… Read more

Updated Product 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 MDS in particular. Below you’ll find information to locate updated and new content. SQL Server 2008… Read more

New White Papers Available

New Master Data Services white papers are now available on MSDN. For an application-agnostic overview of Master Data Management, see Organizational Approaches to Master Data Management. For the steps needed to configure Master Data Services to work with a SharePoint workflow, see SharePoint Workflow Integration with Master Data Services…. Read more

Subscription Views – Part 3: Padding Level-Based Views

(this post was contributed by Val Lovicz, Principal Program Manager on the MDS Team) Background This post is the third in a series on Subscription Views in SQL Server 2008 R2 Master Data Services (“MDS”). In the first post, I described how to create standard subscription views. In this post I will describe how to… Read more