EIM

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

Bulk Loading into MDS using SSIS

Bulk Loading into MDS using SSIS

Each entity in SQL Server 2012 Master Data Services (MDS) will have it’s own staging table (stg.<name>_Leaf). Using this staging table, you can create, update, deactivate and delete left members in bulk. This post describes how to bulk load into an entity staging table and trigger the stored procedure to start the batch import process. … 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

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

Presenting at Tech Days Hong Kong 2013

Presenting at Tech Days Hong Kong 2013

I’ve been invited to the Microsoft Tech•Days event in Hong Kong next month – March 12th to 14th. This will be my first trip to Hong Kong, and I’m really looking forward to presenting to an international audience. I’ll be doing three SSIS related sessions: EIM – Bringing Together DQS, MDS and SSIS SSIS Performance … Continued

SQL Saturday #146 | Nashua, New Hampshire

SQL Saturday #146 | Nashua, New Hampshire

I’ve been invited to speak at SQL Saturday #146 in Nashua in October. I’ll be presenting two talks related to Data Movement: Efficient On-Premise to Cloud Data Transfer Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just … Continued

Speaking at the DevTeach Montreal Conference

Speaking at the DevTeach Montreal Conference

I’ve been invited to speak at the DevTeach conference in Montreal this December (10th and 11th). I’ll be showing how to put together Enterprise Information Management (EIM) solutions using SSIS, DQS, and MDS. I’ve done EIM talks before (my favorite being the presentation I did with Matthew Roche at TechEd earlier this year), and will … 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

Speaking at the Ottawa SQL PASS meeting tonight (5/10)

I’ll be driving up to Ottawa later today to speak at the Ottawa PASS chapter’s user group meeting. Tonight I’ll be talking about Data Quality Services (DQS), with a focus on a couple of demos that show how DQS, MDS, and SSIS can be used together to form an Enterprise Information Management (EIM) solution. The … Continued