Master Data Services TeamBlog for the Microsoft SQL Server Master Data Services (MDS) team. Blog posts are contributed by various team members.http://sqlblog.com/blogs/mds_team/atom.aspxCommunity Server2015-06-02T17:34:00ZSQL Server Master Data Services 2016 released!http://sqlblog.com/blogs/mds_team/archive/2016/06/16/sql-server-master-data-services-2016-released.aspx2016-06-16T23:08:00Z2016-06-16T23:08:00ZSQL Server 2016 was released recently. With that, all the new capabilities in Master Data Services are generally available. The details regarding the new capabilities are available on What's New in Master Data Services (MDS) . To download SQL Server 2016, go to Evaluation Center . To download Excel Add-in for Master Data Services, go here . We are very excited about the release. We would like for you to try the product and provide us any feedback....(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/06/16/sql-server-master-data-services-2016-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=61477" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services 2016 Performance Enhancementshttp://sqlblog.com/blogs/mds_team/archive/2016/04/15/master-data-services-2016-performance-enhancements.aspx2016-04-15T20:49:00Z2016-04-15T20:49:00ZMDS 2016 includes many improvements to performance and capacity. This document shares some early performance test results that compare MDS 2014 with pre-release MDS 2016. The tests were run on an Azure GS3 Virtual Machine (8 cores, 112 GB memory, 1 TB premium storage). The test data consists of a model with 7 entities and 2 versions. The largest entity contains 7 million members per version and 18 attributes, 6 of which are domain-based. MDS 2014 SP1 MDS 2016 (pre-release) Operation Time Time Versus...(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/04/15/master-data-services-2016-performance-enhancements.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=61069" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services - SQL2016 RC1(March) is Releasedhttp://sqlblog.com/blogs/mds_team/archive/2016/03/18/master-data-services-sql2016-rc1-march-is-released.aspx2016-03-18T23:06:00Z2016-03-18T23:06:00ZWhat is New: Added negate operators support for Business Rules. Seven new business rule conditions were added to provide a complete set of conditions. For more information, see Business Rule Conditions (Master Data Services) . Sample Model Deployment Packages Updated. The sample packages were updated to support new SQL 2016 features. For more information, see Samples: Model Deployment Packages (Master Data Services) . Download Links: SQL Server 2016 : https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016...(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/03/18/master-data-services-sql2016-rc1-march-is-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60858" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services - SQL2016 RC0(February) is Releasedhttp://sqlblog.com/blogs/mds_team/archive/2016/03/18/master-data-services-sql2016-rc0-february-is-released.aspx2016-03-18T22:43:00Z2016-03-18T22:43:00ZWhat is New: Derived Hierarchy Management Experience Improved The derived hierarchy management experience in MDS has been improved. For more information about this feature, see Create a Derived Hierarchy (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...(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/03/18/master-data-services-sql2016-rc0-february-is-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60857" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxHands On Labs for Master Data Serviceshttp://sqlblog.com/blogs/mds_team/archive/2016/02/18/hands-on-labs-for-master-data-services.aspx2016-02-19T00:12:00Z2016-02-19T00:12:00ZHave you been looking to develop a Master Data Services solution or try out the new features in SQL Server 2016? We have published couple of Hands On Labs for you to use. ...(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/02/18/hands-on-labs-for-master-data-services.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60670" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services - SQL2016 CTP3.3(January) is Releasedhttp://sqlblog.com/blogs/mds_team/archive/2016/02/04/master-data-services-sql2016-ctp3-3-january-is-released.aspx2016-02-04T20:49:00Z2016-02-04T20:49:00ZWhat is New: Business rule changes New and easier-to-use web UI administration page Support for NOT conditional operator Support for ELSE section that contains a set of actions to execute if the IF condition is false Removed management UI from Excel add-in Added support for purging (hard-deleting soft-deleted members) of an entity version. Added to the web explorer page a button to open the current entity view in the Excel add-in. Download Links: SQL Server 2016 : https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016...(<a href="http://sqlblog.com/blogs/mds_team/archive/2016/02/04/master-data-services-sql2016-ctp3-3-january-is-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60571" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services - SQL2016 CTP3.2(December) is Releasedhttp://sqlblog.com/blogs/mds_team/archive/2015/12/17/master-data-services-sql2016-ctp3-2-december-is-released.aspx2015-12-17T19:56:32Z2015-12-17T19:56:32Z&#160; 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...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/12/17/master-data-services-sql2016-ctp3-2-december-is-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60248" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxMaster Data Services - SQL2016 CTP3.1(November) is Releasedhttp://sqlblog.com/blogs/mds_team/archive/2015/12/03/master-data-services-sql2016-ctp3-1-november-is-released.aspx2015-12-04T03:28:19Z2015-12-04T03:28:19ZSQL 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&#160; some&#160; 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=5001...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/12/03/master-data-services-sql2016-ctp3-1-november-is-released.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60130" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxIn SQL Server 2016 Master Data Services how to filter Domain Based Attribute drop down listshttp://sqlblog.com/blogs/mds_team/archive/2015/12/03/in-sql-server-2016-master-data-services-how-to-filter-domain-based-attribute-drop-down-lists.aspx2015-12-04T03:17:08Z2015-12-04T03:17:08ZA 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 the City entity, which references the StateProvince entity. When adding/modifying Customers, it can be inconvenient to select from a potentially large list of Cities from all StateProvinces....(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/12/03/in-sql-server-2016-master-data-services-how-to-filter-domain-based-attribute-drop-down-lists.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=60129" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxWhat's New in Master Data Services - SQL2016 CTP3 (Oct) Releasehttp://sqlblog.com/blogs/mds_team/archive/2015/10/30/what-s-new-in-master-data-services-sql2016-ctp3-october-release.aspx2015-10-30T22:38:00Z2015-10-30T22:38:00ZIn 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 by the administrator. For more information, see Change Sets (Master Data Services) . Attribute Filters For a domain-based attribute, for a leaf member, you can use a filter parent attribute...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/10/30/what-s-new-in-master-data-services-sql2016-ctp3-october-release.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=59923" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxWhat's New in Master Data Services - SQL2016 CTP2.4 (Sep) Releasehttp://sqlblog.com/blogs/mds_team/archive/2015/10/15/what-s-new-in-master-data-services-sql2016-ctp2-4-september-release.aspx2015-10-15T18:57:00Z2015-10-15T18:57:00ZSQL Server 2016 Community Technology Preview 2.4 is publicly released and the latest SQL Server bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 . MDS Excel Add-in can be found at : https://www.microsoft.com/en-us/download/details.aspx?id=47343 In CTP2.4 MDS introduced feature to extend Business Rules conditions and actions. Business Rules Extension Business rule is a rule that you use to ensure the quality and accuracy of your master data. You can use a business...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/10/15/what-s-new-in-master-data-services-sql2016-ctp2-4-september-release.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=59778" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxWhat's New in Master Data Services - SQL2016 CTP2.3 (Sep) Releasehttp://sqlblog.com/blogs/mds_team/archive/2015/09/03/new-features-in-sql-ctp2-3-releases.aspx2015-09-03T20:11:00Z2015-09-03T20:11:00ZWe are excited to share the new features which shipped in SQL CTP2.3 public release. You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343 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 Data Services Add-in for Excel you can manage Business...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/09/03/new-features-in-sql-ctp2-3-releases.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=59485" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxWhat's New in Master Data Services - SQL2016 CTP2.2 (July) Releasehttp://sqlblog.com/blogs/mds_team/archive/2015/07/23/what-s-new-in-master-data-services-sql2016-ctp2-2-july-release.aspx2015-07-23T19:45:00Z2015-07-23T19:45:00ZSQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 In CTP2.2 MDS introduced following changes: 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 performance. For more information, see Custom Index (Master Data Services) . Entity Sync Relationship You can share...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/07/23/what-s-new-in-master-data-services-sql2016-ctp2-2-july-release.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=59193" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxWhat's New in Master Data Services - SQL2016 CTP2 (May) Releasehttp://sqlblog.com/blogs/mds_team/archive/2015/06/05/what-s-new-in-sql2016-ctp2-release.aspx2015-06-05T19:22:00Z2015-06-05T19:22:00ZSQL Server 2016 Community Technology Preview 2 is publicly released and the latest SQL Server bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 . Improved Performance and Scale 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...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/06/05/what-s-new-in-sql2016-ctp2-release.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=58803" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspxDeprecated in SQL 2016: Explicit Hierarchies and Collectionshttp://sqlblog.com/blogs/mds_team/archive/2015/06/02/deprecated-explicit-hierarchies-and-collections.aspx2015-06-02T22:34:00Z2015-06-02T22:34:00ZThe 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 to take the place of EHs: 1. Recursive Derived Hierarchies (RDH) can now be used to assign member security permissions In the above example, the...(<a href="http://sqlblog.com/blogs/mds_team/archive/2015/06/02/deprecated-explicit-hierarchies-and-collections.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=58807" width="1" height="1">mattandehttp://sqlblog.com/members/mattande.aspx