SQL Server 2012 RC0 – What’s New in DQS?

SQL Server 2012 RC0 is out there, with a bunch of new DQS features and improvements! In addition to usability improvements and bug fixes, we have introduced the following new features in this release: New Features Import knowledge from a cleansing project to a knowledge base – a new feature that is available from the domain values screen,…


DQS Blog – TechEd Demo

Hi everyone, I’ve been getting many requests to publish the files and KBs used in the DQS TechEd presentation (available here). So I know it’s a bit late, but still – here it is… For those of you who haven’t viewed the presentation yet – the high level story is about a major service provider…


Learning Resources for Data Quality Services (DQS) in SQL Server "Denali" CTP3

We have put together a comprehensive set of learning resources for DQS that you can use to quickly understand/learn things about DQS, install/configure it, and then use it. DQS FAQ We understand that you have a lot of questions about DQS, and that’s why we have put together list of frequently asked questions (FAQ) about DQS….

3

How to add Reference Data Services in Data Quality Services (DQS)

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality solution. You can define knowledge manually; acquire it from data samples of your organization, or knowledge provided by third party services. We call this Reference Data Services (RDS). DQS makes it easy to cleanse and enrich your data using leading reference data service providers…


Using the SSIS DQS Cleansing Component

  As part of our DQS CTP3 offering, we are releasing a new DQS SSIS component. This component incorporates the DQS cleansing functionality into an SSIS data flow.   When should I use the SSIS DQS Cleansing Component? The DQS Cleansing component can add value when: 1.       Cleansing should be performed as a batch process….


Installing and Configuring Data Quality Services

  After you’ve downloaded Denali CTP3, it’s time to install DQS! Here you can find some important information that will help you install and configure DQS successfully. Data Quality Services (DQS) contains three components: DQS server, DQS client, and a DQS Cleansing SSIS component. The DQS server is installed on top of the SQL Server Database Engine,…


Introducing Data Quality Services

Welcome to the SQL Server Data Quality Services Team Blog!     SQL Server Data Quality Services (DQS) is the new innovative data quality product delivered as part of SQL Server “Denali” release. DQS is a knowledge-driven data quality solution. It enables you to build a knowledge base, and use it to perform a variety…