SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Picking the Right Type of Tool For the Job

By Andy Warren,

Today we have a guest editorial from Andy Warren as Steve is traveling.

I imagine most of you have heard the bit of wisdom that says "use the right tool for the job". I think generally that's good advice, but perhaps not applied as often as it should be. Sometimes it’s because we don't recognize the problem as having a particular type of tool that applies. Sometimes it feels like overkill to get the "right tool" either due to cost or because it will only be used once. Sometimes it's because we're not comfortable learning a new tool or worry that we'll spend more time trying to master it than we get back in productivity. I've fallen into all of those traps more than once!

I made a note to write about this after wrapping up a project recently. I work for a small company on a small operations team. We don't usually take on projects that span months or have a lot of dependencies or need down to the minute planning. Trello (or anything in that class) combined with a weekly meeting works well for our needs, though sometimes we'll have a spreadsheet with details or a rough outline. Informal and effective - for our usual work.

The project was a colocation facility to cloud migration. Over the course of months we marched along to our plan using the tools we usually use. When it was time to plan the actual switchover, we started listing tasks in the spreadsheet and that still worked well. Until we got to the point of determining how long we expected to take during the planned outage window. We put in the tasks, rough estimates on the duration of tasks, and then hit the wall when we needed to see what work could be done in parallel. It's not that you couldn't figure that out in a spreadsheet, but was it the right type of tool?

I proposed using MS Project because it's designed for that type of problem, and I had used it just enough to think it wouldn't cost us a lot of time to move to it. The team didn't respond with enthusiasm. Using MS Project for a plan with 80 or 90 tasks? MS Project is for, well, big stuff! I loaded up the task list and at the next planning meeting it took everyone about two minutes to realize that yes, this is better. Not much different than a spreadsheet for entering tasks and you get a lot of extra capabilities.

So at that point we were (arguably!) using the right type of tool for the job. But was it the right tool? For figuring out the plan it worked fine, but we were trying to plan tasks that in a lot of cases had a duration of five minutes or less (shut down this service, confirm this matched, etc) and we couldn't get Project to show it quite as well as we wanted in a gantt chart.

As we continued to plan we knew that we'd need to have multiple people making edits for a while, that we'd need to put the live view up on status monitors, and that trying to get everyone using Project was one more thing to do. With the plan pretty much in place we spent a couple of hours looking at web based alternatives and found several that would import a Project file and of those one that was both pay as you go and had just the gantt view we wanted.

We'd gone from a tool to the right type of tool to the tool that best met our needs. Good stuff.

Total article views: 45 | Views in the last 30 days: 1
Related Articles

Build Great Looking Excel Spreadsheets

Exporting data from your database and building reports is easy with Reporting Services, but sometime...


Leaving a contract project

Leaving a contract project


Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open sourc...


SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to ad...


Trigger will not export to Excel Spreadsheet

Trigger will not export to Excel Spreadsheet