Author Archives: ssimagine

About ssimagine

My name is Matthew Roche, and I am a Senior Program Manager with the SQL Server product group at Microsoft. I work on Master Data Services and Data Quality Services, and have previously worked on SQL Server Integration Services. Although I work for Microsoft and will be posting on technical topics, I want to stress that this is a personal blog, and any opinions posted here are mine and mine alone. I built my career around SQL Server and Microsoft technologies for well over a decade before I joined Microsoft as an employee, and I plan on using this blog to share my personal experience and opinions. They may well be shaped by my experience on the SQL Server team, but they’re still mine, and not that of Microsoft, disclaimer, disclaimer, etc., etc..

Damn it Feels Good to be a Trainer

You’ve seen Office Space, so you know the song. I won’t attempt to reproduce the lyrics here[1] but you know where I’m coming from. I’ve been a Microsoft Certified Trainer (MCT) since 1996, and “trainer” has been a key part … Continue reading

Posted in Conference, Training, Work | Leave a comment

Welcome to the new blog – SSIMagine what’s next!

Even though there is five years’ worth of content already, this is the first post for the SSIMagine blog, which will focus on Enterprise Information Management (EIM) and Self-Service Information Management (SSIM) with a spattering of Business Intelligence (BI) thrown … Continue reading

Posted in Welcome | Leave a comment

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

Setting up a SQL Server 2012 RC0 VM

I ran across this excellent article last week, but forgot to share it before I went offline for the Thanksgiving holiday. Fortunately it was waiting for me in a browser tab this morning to remind me. How to Build a … Continue reading

Posted in 2012, Denali, SQL Server | 2 Comments


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