SSIS Classroom Training – Boston and Denver

For those looking for classroom training in SSIS, I’ve got an exciting announcement: I have a brand new course entitled “Building Better SSIS Packages” which I’ll be delivering in Denver and Boston this fall. Here’s a brief into to this course:

There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.

In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages.

I’ll be teaching this course in Denver, Colorado on Friday, September 18th, and again in Boston, Massachusetts on Friday, October 16th. Registration is open for both courses.

Presenting at SQL Saturday in Richmond, VA

This weekend I’ll be traveling to Richmond, Virginia to present at SQL Saturday.  On Friday, March 20th, I will present a full-day session entitled “Real World SSIS: A Survival Guide.” On Saturday, I will share some data cleansing tips in a one-hour session entitled “Dealing with Dirty Data with SQL Server and SSIS.

Registration for the SQL Saturday event is still open. There is still some space available for my full-day session on Friday, but it’s filling up quickly.

Advanced SSIS Training in Dallas

I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and fellow ETL architect Andy Leonard and I will be delivering this new 3-day course March 9-11, 2015 at the Microsoft offices in Irving, Texas. This course is intended for those who have experience using Integration Services who are looking to take their skills to the next level. In this course, we’ll each be sharing experiences and war stories from 10+ years in the data integration space.

Among the topics we’ll cover:

  • Data flow internals
  • Performance design patterns
  • Learning how to fail properly
  • Security in SSIS
  • Deployment design patterns
  • Data quality
  • Metadata management patterns
  • Biml
  • Known limitations of SSIS, and workarounds for them
  • ETL data edge cases

We’ll bring the coffee and lunch for all three days. All you need to bring is your experience using SSIS and your readiness to advance your data integration skills.  Space is still available, and early bird pricing is in effect until February 6th. If you’ve got a team of folks who would benefit from this training, contact me about a group discount. If you’re coming in from out of town, there are lots of hotels close by, including the NYLO right next door and the Hampton Inn about a mile away.

Feel free to contact me with any questions. We hope to see you there!