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 colleague 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

Also, there may or may not be stories of chicken farming.

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!

Join me in DC for a full day of Biml

I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml preconference seminar the day before the upcoming SQL Saturday in Washington, DC.  This seminar, entitled “Getting Started with Biml”, will introduce attendees to the awesomeness of Business Intelligence Markup Language (Biml).

In this course, we’ll cover the basics of Biml syntax, show how to use BimlScript to make package creation even more dynamic, and will demonstrate lots of design patterns through numerous demos.

Registration is now open for this course.  Lunch will be provided.  We hope to see you there!

SMO Videos on JumpstartTV.com

Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the guys at End to End Training.  They have relaunched JumpStartTV.com and I was out there to record some brief training videos on SQL Server SMO programming.  Check out the SMO channel here.  Also, Brian Knight and Grant Fritchey have both posted recent content on the same site, and I encourage you to check those out as well.  Please leave feedback – good, bad or indifferent – on those videos you watch, as viewer feedback is the best way we can improve the quality of content for future videos.

Edit: Since this post, JumpstartTV has been rebranded as SQLShare.com.