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!

Upcoming Presentations in May

atlNext month, I’ll be making a couple of stops at SQL Saturday events in the south.  On May 3, I’ll be attending SQL Saturday #285 in Atlanta and presenting my SSIS Performance session.  I’ll be traveling with my good friend and neighbor Ryan Adams, who is also presenting at the event.  In addition, several of my Linchpin People cohorts are also in attendance, which means I should probably bring along some extra bail money.  Although I’ve been to Atlanta several times, I’ve never gotten to attend the SQL Saturday there, so I’m looking forward to meeting some new people.

SQLSAT308_SPEAKINGThe following weekend, I’ll be visiting the good folks in Houston for SQL Saturday #308.  At this event I’ll be sharing two of my favorite topics: SSIS performance and SSIS scripting.  Having previously attended SQL Saturday in Houston, I know a little about what to expect (Texas barbecue for lunch…. holla!), and I always dig hanging out with fellow Texans down south.  This event will be a first for me in that I’m taking along my whole family for the trip.

If you’re in Atlanta or Houston for either of these events, come by one of my sessions and say hello!  I hope to see you there.

SQL Saturday Lisbon

sqlsatportIt’s a little over a week until this year’s SQL Saturday festivities kick off in Lisbon, Portugal, and I’m very excited to be a part of it.  Registration is nearly full, so if you’re in the area and are planning on attending, register now!

For this event, I’m delivering a full day workshop entitled “Real World SSIS: A Survival Guide”, during which I’ll share design patterns and practical lessons I’ve learned over my 10-ish years in the BI/ETL space.  This workshop will be held on Thursday, April 10th (the Thursday prior to the main SQL Saturday event), and there are still some seats available.  You can register for this workshop online.  I’ve also recorded a teaser video of what’s to come in this workshop.

In addition to the full-day workshop on Thursday, I’ll also be presenting two, one-hour sessions on Saturday.  I’ll be sharing “Handling Errors and Data Anomalies in SSIS” and “15 Quick Tips for SSIS Performance” during the regular SQL Saturday event.

If you plan on attending SQL Saturday in Lisbon, please stop by and say hello!  I’m looking forward to seeing you there.

My event schedule for Fall 2013

As I was browsing my calendar of upcoming events for the remainder of the summer and the fall, I realized two things:

  1. This will likely be the busiest, most travel-heavy three months I’ve ever had, and
  2. I’m going to have to buy my wife something really nice by the time I finish my travels.

Between client travel and community events, I get to spend some quality time with my friends at American Airlines.  But even better, I get to hang out with some of you fine folks!

Among the events at which I’ll be speaking:

SQL Saturday Oklahoma City (Saturday, August 24).  I’ll be presenting “Handling Errors and Data Anomalies in SSIS” while doing my best not to make jokes about Oklahoma.

SQL Saturday Orlando (Friday, September 13 – Saturday, September 14).  On Friday, I’ll be presenting a full day preconference seminar entitled “Real World SSIS: A Survival Guide”.  Since this will be held on Friday the 13th, you can bring your black cat for free with paid admission*.  I’ll be staying for the main event the following day, and will present a brand new presentation entitled “Maximizing SSIS Package Performance”.

SQL Saturday Denver (Friday, September 27 – Saturday, September 28).  I’ll spend Friday with some of you talking again about Real World SSIS, followed by my “Maximizing SSIS Package Performance” presentation on Saturday.  Somehow this lineup seems strangely familiar.

SQL Connections (Monday, September 30 – Thursday, October 3).  I get to present two sessions at the national SQL Connections event in Las Vegas.  I’ll be again delivering “Maximizing SSIS Package Performance” (this is turning out to be a popular selection) along with “Cleaning Up Dirty Data in SSIS”.  Both of my sessions are on Tuesday, which means I’ve got three unallocated days in Las Vegas.  Is there anything fun to do in Vegas for three days?

Biml Workshop (Tuesday, October 15).  I’ve been spending a lot of time using Biml lately, and I’ve finding it to be a centerpiece in my toolset these days.  In this full day workshop, I’ll be presenting with Andy Leonard and Scott Currie to demonstrate how Biml can be used as a tool for rapid development and easy maintenance of SSIS packages.

SQL PASS Summit (Tuesday, October 15 – Friday, October 18).  The SQL PASS Summit remains my favorite SQL Server event, and I get the opportunity to present for the third year in a row.  I’ll be delivering a session entitled “Data Cleansing in SSIS”.  I’m also planning an after-hours session entitled “How to Embarrass Yourself at Karaoke”, which may or may not appear in your event guide.

SQL Saturday Tampa (Friday, November 8 ? – Saturday, November 9).  I’ll be delivering a full day precon ahead of the Saturday event (presumably Friday, or perhaps Thursday) as well as one or more sessions at the main event on Saturday.

In addition to the events that have already confirmed, I’ve also submitted for the SQL Saturday BI event in Charlotte just after the PASS Summit, and may also submit to our hometown SQL Saturday event in Arlington, TX in November.

It’s going to be a busy and fun fall travel season.  I’m looking forward to getting to catch up with many in my #SQLFamily during the next several months.

* Not really. Please leave your cats at home, or I’ll be forced to bring my vicious dog to keep them away.