Browse by Tags

Tagged Content List
  • Wiki Page: Community Resources for Data Quality Services (DQS)

    This article contains links to the third-party Data Quality Services (DQS) content/resources created by the community on non-Microsoft blogs and sites. The articles are listed in random order under the appropriate headings. Please feel free to add links to community-generated articles on DQS that...
  • Wiki Page: Troubleshoot Operational Issues in Data Quality Services (DQS)

    This article contains information about the issues that you might encounter while using Data Quality Services (DQS), and how to resolve them. Please let us know if you encounter any other issues (not documented here) while using DQS by posting it on Data Quality Services MSDN Forum . If you...
  • Wiki Page: Data Quality Services (DQS)

    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....
  • Wiki Page: Troubleshoot Installation and Configuration Issues in Data Quality Services (DQS)

    This article contains information about the issues that you might encounter while installing/configuring Data Quality Services (DQS), and how to resolve them. Please let us know if you encounter any other issues (not documented here) while installing/configuring DQS by posting it on Data Quality...
  • Wiki Page: Upgrade DQS: SQL Server 2012 RC0 to SQL Server 2012 RTM

    This article contains instructions to upgrade your Data Quality Services (DQS) installation from SQL Server 2012 RC0 to RTM release. Note This upgrade preserves all of your DQS data (knowledge bases and projects), and you do not have to back it up before upgrading DQS. ...
  • Wiki Page: Upgrade DQS: SQL Server Code-Named “Denali” CTP3 to SQL Server 2012 RC0

    This article contains instructions to upgrade your Data Quality Services (DQS) installation from SQL Server Code-Named “Denali CTP3 to SQL Server 2012 Release Candidate 0 (RC0). Table of Contents Before Upgrading DQS Upgrade Data Quality Server Upgrade Client Components: Data Quality Client and DQS...
  • Wiki Page: Data Quality Services (DQS) FAQ

    DQS is a new feature in SQL Server 2012 that provides you with a knowledge-driven data cleansing solution. For more information about DQS, see Introducing Data Quality Services . The FAQs were originally created by the following people in the DQS product team: Elad Ziklik (Principal Group Program...
  • Wiki Page: Using DQS: How to Find Blank/Empty Values in Your Data

    Data Quality Services (DQS) enables you to easily find blank or empty values in your data source. Further, you can also use DQS to find other values in your data source that are equivalent to blank/empty values (called null equivalent). For example, “NA”, “Not Available”, or “Missing” can be present...
  • Wiki Page: Using DQS: How to Find Special Characters and Extra Spaces between Words in your Data

    You can use Data Quality Services (DQS) in SQL Server to find special characters and extra spaces between words in a string value in your data. You can do this easily by using regular expressions (regex) in a domain rule in DQS. Since you can use regular expressions in a domain rule for a String...
  • Wiki Page: Upgrade DQS: Installing Cumulative Updates or Hotfix Patches on Data Quality Services

    Section 1: In Microsoft SQL Server 2012, there are several kinds of product updates or patches These types of patches are described in more detail in article http://support.microsoft.com/kb/935897 1. Cumulative Updates (CU) are publicly downloadable hotfixes, available from the link at the...
  • Wiki Page: Using DQS: Cleansing Complex Data Using Composite Domains

    This article provides information on how to cleanse complex source data using composite domains in DQS. How do you cleanse your data if you have multiple delimited fields in a single column or have data in delimited columns in a plain text file. For example, consider the following 2 sets of sample...
  • Wiki Page: TSQL Script to delete DQS projects leftover from SSIS DQS Cleansing component

    When you use an SSIS package to run Data Quality Services Cleansing activities via the DQS Cleansing Component, each run produces a Data Quality Project. The resulting Data Quality project is useful for auditing the cleansed data produced from the SSIS package, and also to export the data if a copy...
  • Wiki Page: Accessing your Data on Remote Servers for DQS Operations by Linking Servers

    Data Quality Services (DQS) supports performing data quality operations on your source data only if it is available in: SQL Server table/view in the same SQL Server instance as the DQS databases Microsoft Excel or CSV file What if your source data is available on a remote SQL Server...
  • Wiki Page: Monitor Data Exchange between DQS and Reference Data Service Providers

    One of the key features in Data Quality Services (DQS) is to use knowledge from a cloud-based reference data service ( Windows Azure Marketplace ) to cleanse your data. However, in Data Quality Client, you cannot monitor information about the data exchanged between DQS and the reference data service...
  • Wiki Page: Data Quality Services

    Note: This page is currently a stub article. Add information as you can.
Page 1 of 1 (15 items)
Can't find it? Write it!