SQL Server Data Quality Services (DQS) is a new innovative Knowledge Driven data quality product that is delivered as part of SQL Server “Denali” release.
“DQS enables you to build a knowledge base, and use it to perform a variety of critical data quality tasks – correction, enrichment, standardization and de-duplication of your data.”
“Building a knowledge base is easy – using your own data, DQS allows you to discover knowledge directly from samples of your data, combining computer-assisted and interactive experiences. In addition you can also extend your knowledge with 3rd party IP, using cloud-based reference data services from Windows Azure Marketplace. DQS also provides batch capabilities with a SQL Server Integration Services (SSIS) component, as well as integration with the Master Data Services (MDS) Excel add-in.”
In addition, a full-blown DQS overview presentation from the recent TechEd conference titled “Using Knowledge to Cleanse Data with Data Quality Services” is right embedded below:
[Via:SQL Server Team Blog]