Speaking at the SQL PASS 2014 Summit

imageI’m happy to announce that I will be speaking at the SQL PASS Summit this fall.  The summit will be held during the first week of November in Seattle, Washington.  This will be my seventh year attending the PASS Summit, and my fourth year as a speaker.

This year I will be delivering a new presentation entitled “Building Bullet-Resistant SSIS Packages”:

It’s 2:30 a.m., and you’ve just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: “What could have caused this?”, “What do I do to fix the data from this failed execution?”, and, most importantly, “Could I design the package in such a way that this doesn’t happen again?”

In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we’ll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We’ll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.

I’m looking forward to presenting this session, but more importantly, I’m excited about meeting new community members and catching up with #sqlfamily.  I hope to see you in Seattle in November!

Speaking at PASS Summit 2013

I’m happy to announce that I have been selected to presentlogo_header
at the SQL PASS Summit in Charlotte, North Carolina this October.   I’ll be delivering a session entitled “Data Cleansing in SQL Server Integration Services”, in which I’ll cover various ways to detect and cleanse dirty data using tools built into (or accessible from) SQL Server Integration Services.

This will be my third year to present at the PASS Summit.  As always, I’m happy to be able to participate and humbled to be selected to speak.

On a side note, this is the first time in several years that the Summit has been scheduled to be held outside of Seattle, and the first time it will have been held in Charlotte. Although I have to admit that I’m going to miss Seattle, I’m happy that PASS was open to community feedback requesting that the Summit be occasionally held in locations outside of Seattle.

Now we just need to task someone with finding us a karaoke dive bar in Charlotte.