Doug Lane

SQL Server Entertainer

  • GitHub
  • LinkedIn
  • Twitter
  • YouTube
  • Blog
  • About Doug

Meme Monday: Working with Deadlines

February 6, 2012 by Doug Lane

In response to Tom LaRock’s Meme Monday, I’m writing about working with deadlines. I’m going to take the developer approach and talk in terms of new project deadlines.

My favorite approach to working with deadlines is to take control of the time. Deadlines are much like a line on a graph where time (the x-axis) and scope (the y-axis) intersect. Time and scope have a direct relationship — as scope increases, so does the time necessary to complete the items in the scope. Usually only one of the axes is negotiable. I’ve found the most common scenario to be, “We need a solution that can do this, this, and this. How long will that take?” Rarely have I heard the opposite, “We have this much time. What can we build in that window?” It’s up to me to answer how long the given feature set will take to build and deploy. In other words, I have control over time, not scope.

Before I go on, I must confess that even after years of software development, I am a dreadful estimator of project time. I often fail to consider adequately the interruptions and other projects that will forestall what I’m working on. It’s like the difference between the first time I played golf and the second: noticeable improvement but still horrendous.

My time estimates were totally unreliable until I picked up a book by Steve McConnell called Rapid Development: Taming Wild Software Schedules. In it, I found a truly golden section on time estimation that includes the following passage:

At the time when developers are typically asked to provide a rough estimate, there can be a factor-of-16 difference between high and low effort estimates. Even after requirements have been completed, you can only know the amount of effort needed to within about 50 percent, and by that time most organizations want their estimates to the dollar.

In other words, take your best guess of time, make 25% of that number your best-case scenario and make 400% your worst-case scenario. As you get further along in the project, you can refine your estimates down because there are fewer unknowns that can be introduced. Also, your estimates become more reliable as the project nears completion because people are reluctant to add/change features that will affect the deadline. If features are introduced later on, you can try to reject them citing the effect it would have on time. More likely, you’ll have to renegotiate the timeline (which I’ve found to be easier and more agreeable anyway). Another point mentioned in the passage above is that organizations typically expect far more precision that you are in a position to deliver at that time. If you relent and give a date certain when you yourself are not certain, you’re gambling you can come out on the low side of the estimate funnel, which if you subscribe to this process, gives you only a 50-50 chance of success.

Scotty in Star Trek IV: The Voyage Home (startrek.com)
"A deadline? How quaint."

If compelled to give a date certain, do yourself the favor of selecting the worst-case scenario at that time. In Star Trek III, Scotty confessed he did exactly that (multiplied his repair estimates by a factor of four) to keep up his reputation as a miracle worker.

The range estimate method has worked wonders for me. People understand there is uncertainty in the development process and actually appreciate that I don’t throw out a specific date haphazardly. Being honest about the variability of time required also frees me from the looming specter of a date I was never sold on in the first place. As the project progresses, I give updates with narrowing ranges, until the very end, when I can say we’re ready to go live with the project next Tuesday.

I highly recommend you give this method a try when time is negotiable. I’ve found it results in more realistic expectations and deadlines. By taking control of project time, you make uncertainty a natural and acceptable part of the process, rather than struggling futilely to eliminate it.

Filed Under: Career, Meme Monday

Meme Monday: Just One Christmas Wish

December 5, 2011 by Doug Lane

Tom LaRock (b|t) is back with another Meme Monday, and this month the meme is, “What gift do you want Microsoft to leave for you under the tree this year?” My gut reaction was to ask for a 70-448 exam that didn’t ask loads of questions about troubleshooting and features so problematic that no one actually uses them. (No, I’m not bitter I failed this exam twice. Not at all.) But such a wish would be a little too self-serving; I want Microsoft to bring me something that will benefit a much wider audience. So, for the greater good, here is my wish:

Deliver me a version of SQL 2012 with all the BI features enabled and 100% detached and independent of SharePoint.

Microsoft has made life considerably more difficult for the BI specialists of SQL Server by requiring SharePoint for features like PowerView. If we want to set up a virtual machine to try out these new features, we have to know how to implement and maintain a SharePoint instance, something that is difficult and usually done by a full-time, dedicated SharePoint resource. Furthermore, if we want to deploy these features, it means considerable expense in terms of licensing, setup, and an administrator. A SQL Server BI deployment is now a SQL Server + SharePoint deployment.

What PowerView without SharePoint would feel like.

I’ve often said that Microsoft wrongly equates enterprise reporting needs with enterprise needs (with data-driven subscriptions at the heart of that argument).  Now it seems they are equating effective BI visualizations with document sharing and collaboration. Turn off the sharing aspects of PowerView while preserving users’ ability to explore data visually. Deliver it through the existing Report Manager web UI. Give me an independent version of SQL Server 2012 and you’ll be giving me the power of the new BI features without the cumbersome, expensive, and unwelcome burden of a SharePoint environment that clients neither need nor want to bear.

 

Filed Under: Meme Monday

Meme Monday: What #SQLFamily Means To Me

November 7, 2011 by Doug Lane

Contributing to Thomas LaRock’s Meme Monday, I offer my thoughts on #SQLFamily in haiku form:

Family of friends
bound by passion, vision, love.
Success is cheered on.

I know this doesn’t exactly fit the meme since I’m not explaining what #SQLFamily means, but what I wrote should at least make it evident why #SQLFamily is meaningful.

Filed Under: Meme Monday

Meme Monday: April 2011

April 4, 2011 by Doug Lane

Tom LaRock (blog|twitter) has a blog get-together going called Meme Monday.  The first Monday of every month, he puts out a meme that people can write about.  This month’s meme is “Write a SQL blog post in 11 words or less”. Here’s my contribution:

Found backups disabled.  Ran them myself.  Disaster strikes?  Not for me.

I’m tagging Mark Vaillancourt (blog|twitter) and Yanni Robel (blog|twitter) to join in.

Filed Under: Meme Monday

Subscribe now!

Don't miss new posts as they publish. Enter your e-mail address to subscribe!

Your e-mail address will stay quietly between us, like that time I set the carpet on fire by accident.

Copyright © 2025 · Outreach Pro on Genesis Framework · WordPress · Log in