Master Data Services Team

Master Data Services Team

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

• 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 release, you can now view and manage all changes by model and version. You can also receive email notifications each time a change set status changes for an entity that requires approval. For more information, see View Change Sets (Master Data Services) and Notifications (Master Data Services). Edit Many-to-Many Relationships in Derived Hierarchies You can edit the many-to-many relationship by modifying the mapping entity members. For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services). View and Manage Revision History You can view and manage revision history, by entity and by member. If you have update permissions, you can roll back a member to a previous version. For more information, see Member Revision History (Master Data Services). Download Links: SQL Server 2016 : https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 MDS Excel add in : http://go.microsoft.com/fwlink/?LinkID=398159 Posted Thursday, December 17, 2015 1:56 PM by mattande | 0 Comments Filed under: MDS, Master Data Services, SQL server 2016

• 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 http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. Download MDS Excel add in for CTP3.1 from https://www.microsoft.com/en-us/download/details.aspx?id=50015 Posted Thursday, December 03, 2015 9:28 PM by mattande | 0 Comments

• 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: