Category Archives: DQS

Data cleansing in SSIS, DQS, and MDS

Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS).  The lines are a bit blurred when talking about data cleansing using SSIS, DQS and MDS.  In what product should data … Continue reading

Posted in DQS, MDS/MDM, SQLServerPedia Syndication, SSIS | 1 Comment

Profisee Master Data Maestro

I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months.  I also have been using Microsoft’s Data Quality Services (DQS) for the last couple of months.  While both products are very good and … Continue reading

Posted in DQS, MDS/MDM, SQLServerPedia Syndication | 2 Comments

Missing Data Quality Service (DQS) buttons in Excel

The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it to the MDS repository.  When you make a connection, if a DQS database is installed on the same instance of … Continue reading

Posted in DQS, SQLServerPedia Syndication | 1 Comment

Microsoft Data Quality Services in SQL Server 2012

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012.  The technology was from Microsoft’s acquisition of Zoomix in 2008.  DQS enables you to build a knowledge base and use it to perform … Continue reading

Posted in DQS, SQL Server 2012, SQLServerPedia Syndication | 4 Comments

Microsoft Master Data Services in SQL Server 2012

Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft.  Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007.  Master Data Services is architecturally … Continue reading

Posted in DQS, MDS/MDM, SQL Server 2012, SQLServerPedia Syndication | 7 Comments

SQL Server 2012 (“Denali”): Master Data Services

SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012: Improved web user interface – If you are a current user of MDS in SQL Server 2008 R2 you know that it’s pretty difficult to … Continue reading

Posted in DQS, MDS/MDM, SQL Server 2012, SQLServerPedia Syndication | 1 Comment