Data Quality Services

Links from the SSIS Roadmap Session

Links from the SSIS Roadmap Session

Here are some of the resources I mentioned in the SSIS Roadmap session at the PASS Summit. SSIS Reporting Pack from Jamie Thomson   DQS Matching Transform from OH22 Data   DQS Domain Value Import Destination from OH22 Data There is also a great series of blog posts (part 1, part 2, part 3) on … Continued

Quick Tip: How can I tell when my DQS knowledge base has been updated?

Quick Tip: How can I tell when my DQS knowledge base has been updated?

You can improve data quality in your SSIS data flows by using the DQS Cleansing transform (new in SQL 2012). When you’re using DQS, the data is cleansed according to the rules you’ve built up in the DQS knowledge base. As you update the knowledge base with better rules, your overall data quality goes up. … Continued

EIM presentation material from DevTeach Montreal

EIM presentation material from DevTeach Montreal

I presented an Enterprise Information Manager talk earlier this week at the DevTeach Montreal conference. Unlike my previous talk from TechEd North America, which tackled the problem from the Data Curation (DQS/MDS) side, this talk has a focus on using SSIS to integrate and automate your solution. The demo files are now available from my … Continued

Slides from DQS presentation

Slides from DQS presentation

A big thank you to everyone who came to tonight’s DQS presentation for the New England SQL Server User Group. As promised, you can find the slides on my skydrive share (as well as embedded below). I also wanted to list some of the great DQS resources mentioned in the talk: Performance Whitepaper Getting Started … Continued

Speaking at the New England SQL Server User Group

I’ve been invited to do a presentation about Data Quality Services for the New England SQL Server User Group on October 18th. I’ll be presenting an in depth look at DQS, what some of our customers are currently doing with the product, and might even have time to show how DQS fits into larger Enterprise … Continued

SSIS & EIM Talks From TechEd North America 2012 Now Available

The recordings of my the SSIS sessions I presented at TechEd North America 2012 are now available online. Incremental ETL Using CDC for SQL and Oracle with SQL Server Integration Services (SSIS) 2012 Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

SQL Server 2012 Case Studies for DQS

I’ve had a lot of people ask me recently for real-life examples of how customers are using Data Quality Services (DQS). Even though SQL Server 2012 has been out less than a month, we already have a number of case studies published which describe how DQS plays a key role within a customer’s infrastructure. Most … Continued

DQS – Using the Changes History Panel

DQS – Using the Changes History Panel

The DQS client will automatically sort the list of Domain Values, which can make adding new values to a big list tricky. Once you enter the new value at the bottom of the list, it gets automatically sorted, and you need to scroll up the list to find it again. However, there is a better … Continued

Getting Started with DQS and MDS

If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products. Data Quality Services for SQL Server 2012 Data Quality Basics and Introducing DQS: Video | Slides Knowledge … Continued

Data Quality Services Performance Best Practices Guide – now available!

The Data Quality Services (DQS) Performance Best Practices Guide (or DQSPDPG for short) is now available on the Microsoft Download Center. It covers hardware and setup considerations, how matching policies will impact your performance, and some best practices when using the DQS Cleansing transform in SSIS. I was also happy to see a section in … Continued