Mile High Tech Con

Mile High Tech ConThere’s a brand new business intelligence conference launching next month in Denver, Colorado.  The Mile High Tech Con is a three-day event taking place July 24-26, 2014, and is aimed at business intelligence practitioners, data analysts, and information managers/CIOs. 

From the event website:

Featuring three days of sessions and events focusing on Data Warehousing and Business Intelligence. Mile High Tech Con will highlight innovative topics that will inspire strategic decision making while offering relationship building and networking. Mile High Tech Con will foster collaboration and discussion so that attendees attain the opportunity to connect with industry experts and fellow developers while examining current and upcoming trends.

Among the topics to be covered at this conference:

  • Power BI
  • Predictive analytics
  • Biml
  • Master data management
  • Data quality
  • Dimensional modeling

There’s a great lineup of speakers, including Peter Myers, Marc Beacom, Reeves Smith, Bill Fellows, and others.  I even managed to convince them to let me speak as well!  I’ll be delivering three presentations:

  • Real World SSIS (full day seminar)
  • Error Handling Patterns in SSIS (two-hour deep dive)
  • Introduction to Data Quality Services (one-hour presentation)

This is the inaugural event for the Mile High Tech Con.  They have a model similar to that of SQLBits – one day of full-day seminars (Thursday), one day of deep-dive material (Friday), and one community day (Saturday).  Best of all, the community day is absolutely free.  Registration is currently open, and early bird pricing for Thursday and/or Friday is in effect through next week.

I’m looking forward to attending and presenting at this event.  If you’re going to be there, give me a shout and let’s get together for coffee.

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.

SSIS and PowerPivot training in Baton Rouge

I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of BI and SSIS training next month.  On Wednesday, February 12th, we’ll each be delivering a full-day presentation in Baton Rouge, after which we’ll be joining the Baton Rouge SQL Server User Group for their monthly meeting.

SSIS Training with Tim Mitchell

I’ll be presenting Real World SSIS: A Survival Guide, which is aimed at beginning-to-intermediate SSIS developers.  In this day-long training session, I’ll be sharing and demonstrating many of the ETL lessons that I’ve learned in my 10+ years working in the SQL Server business intelligence ecosystem.

At the same time, Bill Pearson will be delivering Practical Self-Service BI with PowerPivot for Excel, which will provide a crash course for those who are new to PowerPivot.  Following these day-long presentations, Bill will also share more on PowerPivot at the Baton Rouge SQL Server User Group that evening.

Registration for both of these day-long courses is currently open, and early-bird pricing is available for a limited time.  If you’re around the Baton Rouge area and are interested in learning more about SSIS or PowerPivot, we’d love to have you join us next month!

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.

Join me for the 2013 Biml Workshop

Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml.  If you’re not familiar with it, Biml (short for Business Intelligence Markup Language) is a language that allows business intelligence developers to programmatically create and document SSIS packages.  I’ve found this to be incredibly useful in environments that have a large number of packages, multiple steps of staging of data, or frequent changes to the ETL pipeline.  Biml helps to eliminate through automation much of the mundane work of package creation and maintenance.

bimlws If you are interested in learning more about Biml, I’d like to invite you to join Andy Leonard, Scott Currie, and me on Tuesday, October 15th in Charlotte, NC for a full day workshop to discuss the awesomeness that is Biml.  Scott is the CEO at Varigence, the company that developed Biml, and Andy was an early adopter and pioneer of Biml.  In this workshop, we’ll review the Biml syntax and basic usage, as well as demonstrate some Biml design patterns we’ve picked up along the way.

The cost for the workshop is $69, which includes breakfast, lunch, and snacks.  For the next 2 days (until tomorrow at midnight EDT), you can still get early bird pricing of $49.

So if you’re in town for the SQL PASS Summit and aren’t planning on attending a Tuesday precon, I’d encourage you to consider joining us for this workshop.  We hope to see you there!

Upcoming SQL Saturday Precons

SQLSatI’m happy to announce that I’ll be delivering three, one-day preconference seminars this summer prior to three different SQL Saturday events:

For each of these events, I’ll be delivering a full day of content entitled “Real World SSIS: A Survival Guide.”  This day of content consists of many lessons that I’ve learned – many of which were learned the hard way – through my decade or so in this business.  I’ve got lots of demos to illustrate the concepts we’ll be covering.

If you are able to make it to any of these SQL Saturday events, I’d be honored if you’d join me for one of these talks.  Registration is open for all three seminars, as well as each of the SQL Saturday events.  I hope to see you there!

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.

Colorado speaking tour

I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado next week.  I’ll be speaking at these four user groups:

Monday (3/18): Northern Colorado Database Professionals

Tuesday (3/19): Boulder SQL Server User Group

Wednesday (3/20): Colorado Springs SQL Server User Group

Thursday (3/21): Denver SQL Server User Group

At each of these user group meetings, I’ll be delivering a session entitled “When ETL Goes Bad: Handling Errors and Anomalies in SSIS”.  This is the second such tour that I’ve done: two years ago I made trip up there and spoke at 3 of these user groups.  It’s always a pleasure to visit this area – the Colorado SQL community has a lot of great people, and I’ve got several friends in the area that I hope to see.

This will be a working trip, too.  I’ve got a client in the Denver area that I’ll be working with during the week, so I expect it to be a very packed week.  I’m taking the day off on Friday and am staying over until Sunday morning, so I should have two full days to squeeze in some skiing while I’m there.

If you’re in the area, please stop by one of the user group meetings and say hello.  And if you’re up for some skiing on Friday or Saturday, let me know Smile.

Fish and Chips, Robin Hood, SSIS, and Me

I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk about SSIS.  How’s that for tying seemingly unrelated topics together?

I’m happy to report that in addition to my full-day preconference seminar at SQLBits, I’ll also be delivering a regular session entitled Cleaning Up Dirty Data with SSIS on Friday, May 3.  For those unfamiliar, SQLBits is the largest and most well-known SQL Server event outside of the US.  This year’s event will be held in Nottingham, England from May 2-4.  I’ll be speaking all day on Thursday, May 2nd, with the data cleansing session to follow on Friday.

Registration is still open, and until next week you can still get in on the early bird pricing.  If you make it to SQLBits, please do stop by and say hello.