A Plea for Empathetic Communication

17 November, 2008
Communication
0 Comments

It's impossible to over-communicate Sounds a bit strong, but if you think through your real-world experiences, this shouldn't surprise anyone. No matter how hard you try, your message will be missed by someone ... Problem: It's all their fault! Rely on Web 2.0, and ... ... they won't subscribe to the RSS feed; they don't understand the concept, and have no other information sources that supply feeds ... they won't sign up for the email notifications; that feature is hidden,…

MS Project, Early and Often

9 November, 2008
Project Management
0 Comments

99.9% of the project managers I know have at least heard of Microsoft Project (MSP), and all understand it to be a very capable, yet very complex environment for estimating and managing projects. But it's Saturday evening and I'm a bit cynical tonight, so I'll say that 50% of those people don't really understand how it works - and have many reasons why they should not use MSP for this project or that ... ... this is an iterative development…

The Power of Paper in Business Communications

Confucius was wrong - it is good to live in interesting times ... I'm deep-diving into a number of projects at work, while juggling a sudden surge in business travel (the majority of my tweets of late). All of the work involves significant change - different tools & process, or reworking process "traditions" that have ossified over multiple years and a succession of owners. I have developed a stack of notes on a range of topics - excellent blog fodder…

On the Road: Business Travel, Fall 2008

I don't travel a significant amount in my current position, but when I do, it seems to come in chunks. I'm about half way through a round of travel this fall - mostly business, but with some personal travel mixed in. Six cities, three countries in less than four months. Some observations at the halfway point ... @ the Data Center: The Surreal Life I'm finishing this entry around 4am - just off my second night in a row on…

Excel 2007 is a BOB system (Bag’O’Bugs)

5 October, 2008
Hands-On
0 Comments

I am getting seriously aggravated with the flighty behavior of Excel 2007. Yes, I acknowledge that the spreadsheets in question is quite complicated ... shared VBA modules in an XLA file database read/write using ADO array-manipulation for ranges of cells (see this post) lots of macro (VBA) logic to control look/feel of the tabs code to automatically insert formulae into cells ... and so on. However, some of the observed flightiness is specific to the UberSheet, while other weirdness happens…

Agile Methods in a Waterfall World: Speaking In Code

Starting up a new project, and I'm definitely having fun with it. At first glance, it looks like a fairly small, departmental application, but it is actually part of a web of disconnected processes and local databases (ie. "a mess") that support some fairly important master data. Also, the folks I'm working with are much more comfortable in a "waterfall world", with formal requirements followed by code, test, and deploy. Lots of opportunity for process coaching and new methods -…

Best Practices for Process Documentation: Use Cases (3 of 3)

21 September, 2008
Knowledge Management, Project Management
0 Comments

I've been writing about iterative documentation and checklists, and it's easy to see how these are applicable to a number of common IT processes ... Build a server Apply OS patches Move new code into production Initiate a project / programming request Unfortunately, there are plenty of other areas in IT that you think should / could have a definable process ... yet there is always some magic to them, a variable recipe that's difficult to capture in a cookbook…

Best Practices for Process Documentation: Iterations (2 of 3)

Last time, I wrote about checklists, and showed the example of the B-17 preflight. Simple, fits on a single page, and hits all the critical steps, in just the right amount of detail. Plenty of processes in the IT department are made That Much Better if they are accompanied by detailed, effective Process Documentation. Of course, that's all motherhood and apple pie - everyone agrees that the existing checklists are great. But how do you get started? I mean, assuming…

Best Practices for Process Documentation: Checklists (1 of 3)

I've written before about process documentation and the need for checklists - especially for repeatable and complex processes that you may not perform every single day. A written process solves a multitude of issues: Security: For complex processes with integrated platforms, a detailed list keeps you from forgetting key settings, switches, and process steps that you might forget Reality: No matter how "advanced" or "highly engineered" these systems are, there is always something that must be done in just the…

Does Excel 2007 VBA have Sneaky Hidden Issues?

25 August, 2008
Hands-On
0 Comments

I've done a lot of coding over the past few years, on a number of platforms - but since I'm not a full time developer, it's typically limited to VBA, PHP, SQL, some simple web stuff. Still, I've developed some tools that people use - and need to carry forward as the underlying technology moves along. And so, as I've finally made the leap to Office 2007, I had to come to terms with yet another VBA upgrade. I remember…