Microsoft SQL Server Master Data Services

Master Data Services first shipped with Microsoft SQL Server 2008 R2.

Microsoft SQL Server 2016 introduced enhancements to Master Data Services, such as improved performance and security, and the ability to clear transaction logs, create custom indexes, share entity data between different models, and support for many-to-many relationships.

All changes made to the data are validated against the rules, and a log of the transaction is stored persistently.

Violations are logged separately, and optionally the owner is notified, automatically.

The views are generated dynamically, so they contain the latest data entities in the master hub.

[citation needed] SQL Server 2016 introduced a significant performance increase in Master Data Services over previous versions.