Master Data Services – SQL2016 CTP3.2(December) is Released

  In SQL Server 2016 CTP3.2 release, MDS is introducing following features. Purge Soft Deleted Members You can now purge (permanently delete) all soft-deleted members in a model version. Deleting a member only deactivates, or soft-deletes, the member. For more information, see Purge Version Members (Master Data Services). Change Set Email and Management In this… Read more

Master Data Services – SQL2016 CTP3.1(November) is Released

SQL Server 2016 Community Technology Preview 3.1 is publicly released. In this release we Added capability to filter DBA drop down lists Added capability in Excel add in for change sets and approval workflow. Improved usability in  some  Master Data Web User Interface pages. You can down load SQL Server 2016 CTP3.1 bits from:…. Read more

In SQL Server 2016 Master Data Services how to filter Domain Based Attribute drop down lists

A domain-based attribute (DBA) can have as its value any member of the specified domain entity. In the next release, we add the ability to constrain this list of possible values by filtering on the value of another DBA within the entity. Consider the following entity diagram: The Customer entity has a DBA that references… Read more

What’s New in Master Data Services – SQL2016 CTP3(October) Release

  In SQL Server 2016 CTP3 release MDS is introducing following features Change Sets You can use change sets to save pending changes to an entity, and you can view and modify pending changes. If the entity requires approval for changes, you must save the pending changes into a change set and submit for approval… Read more

What’s New in Master Data Services – SQL2016 CTP2.4(September) Release

SQL Server 2016 Community Technology Preview 2.4 is publicly released and the latest SQL Server bits can be found at MDS Excel Add-in can be found at : In CTP2.4 MDS introduced feature to extend Business Rules conditions and actions. Business Rules Extension You can apply user-defined SQL scripts as an extension of… Read more

New features in SQL CTP2.3 releases

We are excited to share the new features which shipped in SQL CTP2.3 public release.  You can download the product here:, and Excel add-in here: In this monthly release, we added a few highly asked features.  Please give it try and look forward to hearing your feedback. Manage Business Rules (MDS Add-in for Excel) In the Master… Read more

What’s New in Master Data Services – SQL2016 CTP2.2(July) Release

SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at In CTP2.2 MDS introduced following changes: 1. Custom Indexes You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query… Read more

Security Improvements

Super User Functional permission: In the previous release, whoever install the MDS originally, is the server admin. The user will have user id 0. There is no easy way to transfer server admin from one user to the other. It will require DB admin go the user table and change SID on user id 0…. Read more

Performance and Scale Improvement in SQL Server 2016

Overall performance and scale Improvement We have made significant improvement on performance from backend database, middle tier services to frontend UI including both WebUI and Excel UI. The performance is improved on all scenarios, especially on the master data loading, while the server side CPU and memory will be lower than previous version. The default… Read more

Deprecated: Explicit Hierarchies and Collections

The SQL Server 2016 version of Master Data Services deprecates Explicit Hierarchies (EH) and Collection and all related components. Members that before were modeled as Consolidated (EH parent) and Collection member types will henceforth be modeled as Leaf members in Derived Hierarchies (DH). This is made possible by new DH features that better enable them… Read more