Question : I just installed MS SQL server, IIS and Master Data services, 2016 version. Everything seems fine, except the […]
Tag: master-data-services
How can we trim bad data and output clean trimmed data using DQS or MDS?
Question : Until now, we have used stored procedures for data massaging and cleansing but we have now decided to […]
Implement AKA in SQL Server Master Data Services
Question : I’m working with a bunch of scientists and we’re trying to implement a master data solution for the […]
sp_Blitz says “Page Verification Not Optimal” on MDS database
Question : I’ve run sp_blitz (version 45) on our test database server. It complains about Database [MDS] has TORN_PAGE_DETECTION for […]
sp_Blitz says “Page Verification Not Optimal” on MDS database
Question : I’ve run sp_blitz (version 45) on our test database server. It complains about Database [MDS] has TORN_PAGE_DETECTION for […]
SQL Master Data Services database has huge leaf member staging table – can I purge old records?
Question : One of our SQL instances has a large MDS database, and virtually 100% of the size is due […]
Can we generate SQL Server MDS Model from an existing database schema?
Question : I have googled this quite a bit and am surprised to not find an answer. I’m considering using […]
sp_Blitz says “Page Verification Not Optimal” on MDS database
Question : I’ve run sp_blitz (version 45) on our test database server. It complains about Database [MDS] has TORN_PAGE_DETECTION for […]
Is Windows 10 compatible with SQL Server 2014 Developer MDS?
Question : I have recently installed SQL Server 2014 Developer edition onto my PN, which has Windows 10 Professional installed. […]
Microsoft Master Data Services (MDS) Migration | 2017 to 2019
Question : We’re in the process of upgrading our MDS instance, from 2017 to 2019, by means of a migration. […]