DQS

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

SQL Saturday Dublin – this weekend!

SQL Saturday Dublin – this weekend!

Less than a week to go before the next SQL Saturday Dublin event! I’ll be presenting a fun session at the main event (Cats, Facebook, and Online Dating with Microsoft BI), and doing a full day training session this Friday (6/21). If you are interested in learning more about SSIS, DQS, and MDS, please see … 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

SSIS, DQS and MDS Training at SQL Saturday #229 | Dublin, Ireland

SSIS, DQS and MDS Training at SQL Saturday #229 | Dublin, Ireland

I’m honored to be invited back to this year’s SQL Saturday Dublin event. I must have done a decent job last year on my SSIS Design Patterns pre-conference session, because I’ve been asked to do another one this time around as part of their Training Day (June 21st). This year I’ll be doing a full … Continued

Presenting to the .NET Montreal community group | May 27th

Presenting to the .NET Montreal community group | May 27th

The fine folks over at Communauté .NET Montréal have invited me to speak at their meeting on May 27th, 2013. I’ll be using this as a practice run for my sessions at the DevTeach Toronto event later that week. Come join us at the Microsoft Montreal office if you’re interested in finding out more about: … Continued

Slides from Bringing Together SSIS, DQS and MDS | TechDays Hong Kong 2013

Slides from Bringing Together SSIS, DQS and MDS | TechDays Hong Kong 2013

A big thank you to everyone who attended my 2nd session at the TechDays Hong Kong event, Enterprise Information Management (EIM): Bringing Together SQL Server Integration Services (SSIS), Data Quality Services (DQS) and Master Data Services (MDS) (wow that’s a long title). The slides are available below. The files for my integrated demo are available … Continued

Dynamic Lookups With Data Explorer

Dynamic Lookups With Data Explorer

In my previous post, I used Data Explorer to grab the list of upcoming events from the SQL Saturday website. Excel has had the ability to grab data from HTML pages for awhile, but using Data Explorer provided a richer set of options, and allowed me to apply a series of transforms to get the … Continued

DevTeach Toronto – May 27-31

DevTeach Toronto – May 27-31

I’ll be heading to Toronto in May to present at the DevTeach conference. I’ll be doing an intermediate (300) level talk about DQS, and an advanced (400 level) talk about developing custom extensions for SSIS (tasks, components, connection managers, and loggers). Data Quality Services (DQS) – End to End Microsoft’s SQL Server Data Quality Services … 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