What’s New in DQS

Microsoft continues to stabilize DQS (and MDS). With SQL Server 2014, we see mostly just fixes and a re-deployment within the SQL Server 2014 environment. The core of MDS and DQS capabilities are pretty much still the same. With DQS you can now do matching of data before loading; in other words, before you load data, you can now confirm that you are not adding duplicate records using SQL Server DQS matching to compare two sources of data: the data from MDS and the data from another system or spreadsheet.

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.