Category Archives: SSIS

So You Want to Work at Microsoft?

I love SQL Server. [1] I love working for Microsoft. [2] For me, these two loves are two things that go well together. I also love competition. If you love SQL Server as much as I do (and if you … Continue reading

Posted in 2012, Certification, Performance, SQL Server, SSIS, Training, Work | 2 Comments

Bring the Special Ops Tour to YOUR City

Calling all SQL professionals! Oh yeah, we used that in the last video, didn’t we… We’re just getting started. Yes we did, and SQL Server fans from across the country have visited and voted for the cities where they … Continue reading

Posted in 2012, Special Ops, SQL Server, SSIS | Leave a comment

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

The SSIS team has just released a white paper on upgrading to SSIS in SQL Server 2012: Summary: Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that … Continue reading

Posted in 2012, BI, SQL Server, SSIS, Upgrade | Leave a comment


If you’ve been following the pre-release versions SQL Server 2012 (previously code-named “Denali”) you’ve probably been using the Community Technology Preview (CTP3) that Microsoft released back in July. You probably have already seen the Release Candidate (RC0) that was made … Continue reading

Posted in 2012, Denali, SQL Server, SSIS | Leave a comment

SQL Server Special Ops Tour

If you’ve been following recent SQL Server news, you know that the next version of SQL Server has lost its “Denali” code name[1] and has been officially named SQL Server 2012.[0] This is actually sort of old news, but I’m … Continue reading

Posted in 2012, Special Ops, SQL Server, SSIS | 1 Comment

SQL Server 2012 RC 0 Available for Download

If you’re working with the pre-release versions of SQL Server 2012, or if you’re thinking about preparing for its release, today is a big day. The first release candidate has been published on the Microsoft Download Center: RC0 is … Continue reading

Posted in 2012, Denali, SQL Server, SSIS | Leave a comment

Your Window Improvements May Vary

I love my new job. This morning I’m sitting in a training session organized by the SQL Server team to bring Microsoft team members up to speed on new Business Intelligence capabilities in SQL Server “Denali”. The session is about … Continue reading

Posted in BI, Denali, SSIS, Training | Leave a comment

Back in the SSISaddle

Testing… Testing… Is this thing on? Although I still get the occasional comment on older blog posts, I assume that pretty much nobody subscribes to my blog anymore for SSIS information. When I joined Microsoft Learning in October 2008, the … Continue reading

Posted in Denali, Personal Life, SSIS, Work | 5 Comments

Transformations are NOT Tasks

This is another one of those “I thought I blogged this years ago” posts. I was having a conversation with a fellow MCT a few days ago, and he described SSIS data flow transformations as “tasks on the data flow … Continue reading

Posted in BI, SSIS | 2 Comments

SQL Server MVP Deep Dives

I’m not a SQL Server Most Valuable Professional anymore[1], but I was when this amazing project got underway, and I am proud to contribute as an author on SQL Server Integration Services. SQL Server MVP Deep Dives is a unique … Continue reading

Posted in Best Practices, Book, Conference, SQL Server, SSIS, T-SQL | 3 Comments