Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server 2012, and SSDT-BI. The installation of these pieces went as expected, and everything appeared to work well – until I attempted to execute an SSIS package on this new… Read more
I think back to 15 years ago, when I was working retail and… Read more
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… Read more
This is the second in a series of posts about SSIS parent-child architecture. You can find the index page here.
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… Read more
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… Read more
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… Read more
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… Read more
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The index page for all posts can be found here.
In this post, I will provide an overview of the architecture and describe the benefits of implementing a parent-child design… Read more
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… Read more
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.
I still remember the first SSIS package I ever deployed… Read more
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:
The most significant event for me… Read more
Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server MVP for 2014. Even though this is my fifth consecutive award, it’s still a rush to get that email each year.
It’s awesome to be a part of such a… Read more
Today is the second day of the 2013 SQL PASS Summit, and I’m again live blogging the event.
8:15: Here we go. Looks like a thinner crowd today. Everyone sleeping in from #sqlkaraoke last night?
8:19: The morning is kicked off with a video montage about networking. It’s good to… Read more
Today is the first full day of the PASS Summit 2013 conference. This year I’m again joining the blogger table and will be live blogging throughout the opening ceremonies and the keynote. This year I’m sitting between Colin Stasiuk and Andy Warren.
I’ll be updating this post periodically through the… Read more
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board elections are upon us, and if you’ were a PASS member as of June of this year, you should receive your ballot via email tomorrow. Remember that this year’s… Read more
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and speak at the third annual SQL Saturday event there. I’ve been invited to speak at each of their three events, and I’ve been impressed with each one of them so… Read more
As I was browsing my calendar of upcoming events for the remainder of the summer and the fall, I realized two things:
- This will likely be the busiest, most travel-heavy three months I’ve ever had, and
- I’m going to have to buy my wife something really nice by the time…
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… Read more
When it comes to ETL, I’m a pessimist. Until proven otherwise, I assume that all data is bad, all connections are volatile, and all transformation logic is suspect. As such, I spent a lot of time addressing how to prepare for and handle errors in the ETL pipeline with SSIS.… Read more