I have worked with Master Data Services (aka MDS) extensively, especially during the engagement at OH22 around a decade ago, and I my interest in the area and that specific is documented in my blog – with the following examples: What is wrong with MDS (Master Data Services) Database in SQL Server 2019 & Master Data Services in SQL Server 2019.
In my professional experience (at OH22) I even had to dig into the internal code of the MDS and from my experience the Software Engineers at Microsoft at MDS team I have talked to – knew much less about it than I did.MDS was launched in SQL Server 2008 R2 and the feature was there with minor changes since SQL Server 2016, with the last update being done in SQL Server 2019. Now, in SQL Server 2025 we have a significant change – Master Data Services are dead. Yes, you read it right – not deprecated and will be removed in the future, not deprecated and unsupported, but – removed.
Read on for a paean to a removed product and commentary on the lack of a viable replacement within Microsoft.