Microsoft sql server MDS

Documents and links related to implement Microsoft MDS

Checklists/Points to be aware off-
Make sure the version of DB and MDS are same.
You can download excel plugin from MDS web url.
Make sure all the required IIS programs are added.
Package file cannot be deployed using MDS-UI if the package has data.
To deploy package with data, use MDSModelDeploy.exe tool (accessed via command line utility)
To deploy package without data you could use create/deploy option at MDS-web UI.

This is a good course to get an idea –
https://www.udemy.com/sql-server-master-data-services-master-data-management/learn/v4/questions/6408682

Master Data Services Installation and Configuration
https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-installation-and-configuration?view=sql-server-2017#InstallMDS

Uninstall and Remove Master Data Services
https://docs.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?view=sql-server-2017

Master Data Services Developer Documentation
https://docs.microsoft.com/en-us/sql/master-data-services/develop/master-data-services-developer-documentation?view=sql-server-2017

 https://docs.microsoft.com/en-us/sql/tutorials/enterprise-information-management-using-ssis-mds-and-dqs-together-%5Btutorial%5D?view=sql-server-2014

float to nvarchar in sql server

when you need to select from one column of datatype float(which has phone number) and insert it in another column as nvarchar- cast wont work

cast : cast([Column_Name] as nvarchar(50)). The result will be in format 9.07235e+009 instead of a 10 digit number (phone number).

use SELECT STR([Column_Name],10,0) ** This is SQL Server solution, for other servers check their docs