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,…


Matching Policy – A Closer Look into Data Quality Services Data Matching

This post demonstrates how you can create a matching policy in a knowledge base and tune it to achieve best results. The screenshots were taken from a later DQS build so you will probably notice some changes to the user interface and functionality comparing to the CTP3 build. What is a Matching Policy? You prepare…

7

Introduction to Data Quality Services Data Matching

It’s all about your data… Whether you are a small shop, mid-size or large organization, one of your most important asset is your data; organizations often spend hundreds of thousands or millions of dollars, a large portions of their information technology (IT) budgets on implementing sophisticated applications, data synchronization systems and data warehouses.Making large investments…

5

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…


The sound of silence – null, empty, space, missing, dummy and other animals

Null, space, dummy, “unknown”, 99999, empty.  All these small and innocent words represent missing data that may have a bad impact on our business execution and analysis. How can a customer participate in my new email campaign if he doesn’t have an email? How can I ship my merchandise quickly and get mailing discounts from…

1

Embarking on the DQ Knowledge Journey – Building my first Knowledge Base

DQS is a Knowledge Driven Data Quality Solution. Knowledge is what every organization and its data users know about their data and want to use for validation and correction.This knowledge can be addressed also as the Data Quality Policy.In DQS this knowledge is stored as Data Domains in the DQS Knowledge Base (KB). There are…

0

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,…