Upgrading DQS to SQL Server 2012 Service Pack 1 (SP1) Release

This post provides information about the Data Quality Services (DQS) improvements in the SQL Server 2012 Service Pack 1 (SP1) release, and step-by-step instructions to upgrade your current installation of DQS to the SP1 release. The steps to upgrade from the SQL Server 2012 RTM or any of the cumulative update (CU) releases to the SP1 release…

1

Pattern Matching in DQS Domain Rules

This post provides you information on how to use the pattern matching rules in DQS while creating domain rules. These are the four pattern matching rules in DQS:  For a pattern matching rule: Any  letter (A…Z)  can be used as a pattern for any letter; case insensitive Any digit (0…9) can be used as a…

4

Excessive database growth issue fixed in DQS in the CU2 Release for SQL Server 2012

The Cumulative Update 2 (CU2) release for SQL Server 2012 is out, and it fixes a DQS issue where the DQS_PROJECTS database use to grow excessively during the knowledge discovery or the cleansing activity. For detailed information about this issue, see http://support.microsoft.com/kb/2685743. You can download and install CU2 release from here: http://support.microsoft.com/kb/2703275. Note: Before installing…

3

DQS supported in a SQL Server 2012 cluster

The SQL Server 2012 Cumulative Update 1 (CU1) release enables support for DQS as part of a clustered SQL Server 2012 setup. Ensure that you install the CU1 release as mentioned under the Resolution section of the following KB article to enable cluster support for DQS: http://support.microsoft.com/kb/2674817. You can download the CU1 package from here: http://support.microsoft.com/kb/2679368. NOTE: When…

0

DQS on the Twelve Days of SQL Server 2012

Call to Action: When you’re done reading this article and checking out the resources it references, please take a moment to comment and let the DQS team know what additional resources you would like provided. If there’s a topic you would like covered in a blog post or webcast or demo, we want to know…


Significant Performance Improvements in DQS with the Cumulative Update 1 (CU1) Release for SQL Server 2012

DQS performance has significantly improved with the release of Cumulative Update 1 (CU1) for SQL Server 2012. The latest DQS Performance Best Practices Guide with the updated performance numbers and other useful information is now available on the Microsoft Download Center: http://www.microsoft.com/download/en/details.aspx?id=29075. Below are the comparative DQS performance numbers between the SQL Server 2012 RTM and CU1 releases: Data…

2

DQS Performance and Best Practices

Hi DQS users, I want to draw your attention to the Data Quality Services Performance Best Practices Guide that describes how to get the best performance out of DQS, especially when working with large data volumes. As a knowledge driven product, DQS requires relevant knowledge for doing a good job improving the quality of your…


One-stop resource for Data Quality Services (DQS) in SQL Server 2012

Find all the resources for DQS at a single location: http://technet.microsoft.com/en-us/sqlserver/hh780961. This page contains links to the following DQS resources: DQS Training Videos by the DQS Product Team DQS Troubleshooting Instructions DQS Performance Best Practices Guide DQS Documentation that includes DQS Help, Installation Guide, and DQS Resources on the TechNet Wiki DQS “How do I”…

0

Learn DQS in a day from the DQS Product Team

We bring you five Data Quality Services (DQS) training videos that provide in-depth information about DQS and ways in which it can benefit your business. These videos were recorded during a 1-day internal DQS training provided by the DQS product team. We recommend that you view the videos in the sequence they are listed here: Data Quality…

0