There’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…
In my first post in this series, I covered the essentials of SSIS parent-child design patterns, including discussing a number of advantages for using such patterns. In this post, I’m going to demonstrate how to build parent-child structures using package deployment mode. SSIS Parent-Child Architecture in Package Deployment Mode Package deployment mode is available (though not the default behavior) in…
I’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…
Next 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…
It’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”,…
I met up for lunch with a good friend and former coworker today, and among the topics of discussion was how we as professionals often neglect personal relationships when work and life get busy. I’ve found that to be especially true since I started working from home last year. I don’t miss a lot about working in an office setting,…
This is the first in a series of technical posts on using parent-child SSIS architecture. In this post, I will provide an overview of the architecture and describe the benefits of implementing a parent-child design pattern in SQL Server Integration Services structures. Parent-Child SSIS Architecture The simplest definition of SSIS parent-child architecture is that it consists of packages executing other…
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. I’ll be presenting Real…
I’m kicking off a new series of blog posts discussing the topic of parent-child architectures in SQL Server Integration Services. The links to the posts in this series are below. Parent-Child SSIS Architecture SSIS Parent-Child Architecture in Package Deployment Mode SSIS Parent-Child Architecture in Catalog Deployment Mode I still remember the first SSIS package I ever deployed to a production environment. …
For me, 2013 was one of the most interesting and busy years of my life. It was a good year for me, especially on the career front, and it’s certainly been the busiest year in several years. Among the highlights of 2013: Going independent The most significant event for me this year was when I fulfilled a long-time dream of…