A Little More On Risk

When you read the title of this post, please be certain to focus on the phonetics and not the spelling of the title. With me? Ok, let’s proceed.

Risk management is pretty simple when you think about it. Microsoft has defined a sick management process that is part of both MOF and MSF, and it looks like this:

I love this picture – it really shows what you need to do and when. But you can boil down the essentials of risk management even further:

  1. Figure out things that could go wrong – these are your risks
  2. For each risk, figure out how likely it is to happen[1]
  3. For each risk, figure out how bad life will be if it happens[2]
  4. Multiply these two together[3] to find the highest priority risks
  5. For the highest priority risks, figure out what actions you’re going to take to keep them from happening
  6. For the highest priority risks, come up with a plan to minimize the damage done if the actions in step 5 don’t work as planned

This makes sense, right? It’s amazing how often you can take small steps early on that prevent big project-threatening problems later on. Many people (and many software development organizations) still don’t see this, however – they think that people who focus on risk early are “being negative” when in fact that they’re simply being proactive.

Why do I mention this today? Well, I’ve run into a problem where someone (no names will be named) has lost around four (although some might say seven) days’ productivity when asking for a little information could have reduced this to an hour or less of lost time. The good news is that I now have a little .NET utility that generates a DTEXEC.EXE /VALIDATE batch file for all of the packages in a project, a solution or a file system folder and its sub-folders. It’s simple, handy and proactive, and it has that certain someone back on track with (cross your fingers!) no more lost time. Now back to work…

[1] This is generally measured in percentage.

[2] This is generally measured in pounds of poop that will hit the fan.

[3] The resulting figure is measured in poopercentage, which is a unit rarely encountered outside risk management, but you can simply think of it as a number if you’d like.


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..
This entry was posted in dev, MOF, MSF, Process, SSIS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s