Share via

Data Quality Services (DQS)

  • Article

This page contains links to all the Data Quality Services (DQS) resources that are available on the TechNet Wiki.

DQS, introduced in SQL Server 2012, is a knowledge-driven application that lets you perform a variety of data quality operations such as cleansing, matching, and data profiling. The heart of DQS is the knowledge base that contains a set of data domains and their relevant metadata information that you build using DQS, and then use it for performing data quality operations. DQS also supports out-of-the-box cloud-based reference data for friction-free data quality operations in addition to configurable third-party reference data sources. DQS is a rapid, easy-to-deploy, easy-to-use data quality environment, and can be set up and used practically in minutes. DQS also integrates with other SQL Server features, such as Integration Services and Master Data Services, for an integrated easy-to-use cleansing and matching experience respectively. For more information about DQS, see DQS Documentation on MSDN.

Getting Started

  • [[articles:Data Quality Services (DQS) FAQ]]
  • [[articles:Presentation Transcript: Introducing SQL Server 2012 Data Quality Services (en-US)]]
  • [[articles:SQL Server 2012 Developer Training Kit BOM]]  

Using DQS

  • [[articles:Using DQS: Cleansing Complex Data Using Composite Domains]]
  • [[articles:Using DQS: How to Find Blank/Empty Values in Your Data]]
  • [[articles:Using DQS: How to Find Special Characters and Extra Spaces between Words in your Data]]
  • [[articles:Accessing your Data on Remote Servers for DQS Operations by Linking Servers]]
  • [[articles:Monitor Data Exchange between DQS and Reference Data Service Providers]]
  • [[articles:SQL Server 2012 Data Quality Services (DQS) for Testing Teams]] 

Troubleshooting and Maintenance

  • [[articles:Troubleshoot Installation and Configuration Issues in Data Quality Services (DQS)]]
  • [[articles:Troubleshoot Operational Issues in Data Quality Services (DQS)]]
  • [[articles:TSQL Script to delete DQS projects leftover from SSIS DQS Cleansing component]]

Upgrading DQS

  • [[articles:Upgrade DQS: SQL Server Code-Named “Denali” CTP3 to SQL Server 2012 RC0]]
  • [[articles:Upgrade DQS: SQL Server 2012 RC0 to SQL Server 2012 RTM]]
  • [[articles:Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services]]

Community Resources

  • [[articles:Community Resources for Data Quality Services (DQS)]] 

See Also (Not on TechNet Wiki)

[[articles:Master Data Services (MDS)]]