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

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 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 You can apply user-defined SQL scripts as an extension of… 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 http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 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

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

Troubleshooting logging improvement

Troubleshooting logging improvement In the SQL Server 2016, we did logging improvement to improve the debug ability and make the troubleshooting easier. 1.       Tracing setting in the web.config     <sources>       <!– Adjust the switch value to control the types of messages that should be logged.            http://msdn.microsoft.com/en-us/library/system.diagnostics.sourcelevels            Use the a switchValue of Verbose… Read more

Transactions, Validation Issue and Staging table cleanup

Transactions, Validation Issue and Staging table cleanup: Master Data Services previous versions didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes these tables can grow exponentially and lead to performance degradation and storage space issues. In… Read more

What’s New in SQL2016 CTP2 Release

SQL Server 2016 CTP2 — Now Available for public download.  In CTP2 release, there are many new MDS features.  What’s New for MDS  Improved Performance Performance improvements enable you to create larger models, load data more efficiently, and get better overall performance. This includes improvement the performance of the add-in for Microsoft Excel has been… Read more

How to cleanup transaction logs, Validation issues and Staging tables

Master Data Services till recently didn’t have a supported way to clean the transaction logs, validation issues history and Staging tables. For a MDS system with lot of data changes and ETL processes over the period these tables can grow exponentially and lead to performance degradation and storage space issues. To overcome this problem in… Read more