February, 2011

...now browsing by month

 

Qualities of Successful Project Teams

Friday, February 25th, 2011

The task of managing projects can be daunting to say the least. Projects are about change and as a general rule change is met with resistance. If the very nature of change management weren’t challenging enough, today’s economy mandates a globally influenced culture. More than two-thirds of projects have a global influence. This means that team members, stakeholders, end users and even sponsors could be anywhere around the world. Long distance communication and the need to share information and cultural differences have driven the development of technology solutions that are universally accessible and useful. Regardless of technological advances, there are basic project management principles that have proven timeless.

Let’s explore three qualities that will empower any project team. Whether you are implementing the use of new software, transitioning to cloud computing solutions, or developing private applications you will get better and faster results when focusing on these qualities. So, here is a quick snap shot:

  • Team Work
  • Clarity
  • Innovation

Team work, in short, is the ability to achieve specific goals through collaboration. Someone once said, “All the ideas to get ahead aren’t in one head.” Every individual, department, or entity brings a unique value to our projects. Often the same contributors also bring differences that can complicate progress.

One of the greatest complications is agreeing on project values. Are we most concerned about quality, or our deadline? The outside salesperson who initiated the project understands the customer’s demands and needs and may be insistent on a timely delivery regardless of practicality. On the same project team the engineering department may be insisting on frequent quality checks that seem to slow the progress. Ignoring either stakeholder will result in conflict and delays. Strong project leaders clearly define the project values in terms of what matters most on the project.

Another complication is efficient collaboration when different stakeholders may use different technology or for the same technology for a different use. On a recent project a customer received resources late because of a simple miscommunication resulting from differences in the way our corporate software was used. When an order is placed, two dates are required: a due date and a follow-up date. Our department uses the follow-up date as a check point to confirm timely delivery through freight tracking. Another team member had spent time in another department that never sourced projects externally resulting in fewer variables on resource deliveries. They simply matched the due date and follow-up date. As a result critical resources were not followed up and ended up late without a heads-up. Unfortunately, you won’t always identify these differences right away. The following tips will help reduce occurrences.

  • Clarify which applications are required.
  • Ensure that all team members are familiar with applications and how they are to be used.
  • When familiarity is low assign someone the role of data entry and information management.
  • If software isn’t already in use for project collaboration, consider cloud based applications.
  • If your team is global or in different facilities, cloud or web-based solutions may save time and money.
  • Spend 10 minutes of your meetings for training on the use of applications. I find that YouTube is a great resource for these training sessions.

One last key to team effort is facilitating variances and change. At the onset of the project plans are made based on information available. Throughout the project variables and crisis may force team members to deviate from the original plan. Make it easy for qualified individuals to make changes when needed. The following guidelines will reduce the impact of such changes.

Establish change limitations including cost of change, schedule impact of change, and predecessor impact of change.

  • Cost of change limits suggest that changes with no greater impact on project cost than X may be made by the task leader.
  • Schedule limits work two ways. If the change will result in a delay acceptable delays must be defined. If a change will shorten the time needed to complete the appropriate stakeholders need to be informed.
  • Predecessor impact is simply a matter of identifying who may be impacted by the change and making sure they are involved with the decision.

Establish change and change order protocol to avoid organization wide chaos.

  • Define processes for documenting all changes made
  • Make sure the entire team knows about the changes even if they are not directly impacted. Brief email blasts or a five minute review of changes during a meeting is fine.
  • Adjust all collaboration applications, such as MS Project, when changes are made.

Establish communication standards to keep the team collectively involved as the project completes.

That brings us to the second quality of successful project teams. Clarity is created when we communicate openly, consistently and universally. By universally I mean that we are using language and medium that is relevant to everyone involved. I was on a project where we were sending updates to the end user weekly. About four weeks into the project we learned that the user rarely checked his email and then usually only scanned the subject line. As a result he had no idea that the project delivery had changed and was awaiting his PO to bill it out. From this miscommunication we learned to do two things on all future projects:

  • Always determine preferred medium for communication. (The above user preferred the intranet discussion forum over email)
  • Always clarify email content using the subject line

One last tip that will help you communicate with clarity is to eliminate vague language. As an example don’t use phrases like ASAP or “when you can get around to it.” Say exactly what you want or mean. Keep in mind that what people hear and what you say are often two different things. I once told a user that a resource would most likely have a two day lead for delivery but that I might have it as early as tomorrow. All he heard was “tomorrow.” The next day he was irate that his resource had not arrived. I learned to simply promise only what I knew I could deliver. If the resource is available early the user is pleasantly surprised.

Last but not least, be innovative with your projects. One way to build innovation into your projects is to explore lessons learned throughout the project and at the end of a project. Identify what has or has not worked and be willing to try new things. I used to be a MS Project exclusive user. I now prefer web-based collaboration solutions with high compatibility with MS Project.

By: Bill “The Builder” Carpenter has more than twenty years of project management experience. He has hands on project leadership experience as well as ten years of experience as a project management trainer. He has authored over a dozen books and audio programs. He is available for keynotes and web based training.  He teaches practical applications of MS Project, MS Office and cloud computing solutions.

Let Us Pimp Your Office!

Tuesday, February 22nd, 2011

ASPE is holding its Pimp My Office contest, and we’re giving one lucky winner gadgets and gizmos galore (i.e. all those office and tech items you covet but can’t get your company to shell out for).  All you have to do is say you want to be pimped and you will be entered in our drawing to win on June 30th.  But keep following our ASPE-IT blog throughout the entire contest; during that time we’ll have mini contests including:

  • What’s in this pimped office?
  • How much did this pimped office cost?
  • Photo contest for why you deserve a pimped office.

So, not only do you get a chance to win some bling and pimp your office this summer, you could win various tech gadgets (we’re talking about the latest, greatest, and perhaps comical) along the way.

Pimp My Office!

You can find contest updates on the ASPE-IT blog, or by following @ASPE_Inc on twitter.
terms & conditions

SQL Server Performance Tuning Myths

Tuesday, February 22nd, 2011

As a SQL Server administrator, performance tuning is a large part of your responsibility. Regardless of the version you’re using (SQL Server 2005, 2008 or 2008 R2), you can do many things to improve the performance of the server over the out-of-box installation. Additionally, you can do many things to improve the performance of specific databases. Over the next few weeks, I’ll be posting about performance tuning for the server, specific databases and even specific queries. In this post, I’d like to begin by dispelling some myths of performance tuning that float around in the industry.

Three myths seem to persist in the area of performance tuning:

  • If processor utilization is high, I need a faster processor.
  • The greatest impact on performance is determined by the application code.
  • An optimized server is the only key to database server performance.

I’ll explore each of these myths and explain why they are wrong and what the alternate truth actually is.

High Processor Utilization

When you analyze processor utilization and it averages more than 60-70 percent utilized, it can be an indicated of poor performance. However, administrators often assume that an over-utilized processor is best repaired by installing a faster processor. This may not be the case. For example, if you have insufficient RAM in the server, much processor time will be utilized managing virtual memory. Data must be read from RAM and placed on the hard disk and from the hard disk and placed into RAM. All of this swapping is performed by the processor.

The point is that the myth of a single point of pain in performance analysis is rarely true. Instead, one thing is seldom the culprit. When performing analysis, you should always analyze the following hardware components at a minimum:

  • Memory
  • CPU
  • Storage
  • Networking

In some very rare cases, monitoring video performance may be important on a server, but most video demands are on clients these days. If you analyze the four listed items, you’re more likely to locate the real performance issue than if you analyze only one thing. Remember, you’re dealing with a system and not a single component.

Application Code

The second myth indicates that a well-written application will always perform well. This statement is simply untrue. Instead, a well-written application that accesses a well-designed database across a well-planned network will perform well. My point is that we must carry the systems thinking of the first myth into this second myth and even the third.

Yes, you do want well-written applications; however, a poorly written application running against a well-designed database will often perform better than a well-written application running against a poorly designed database. The point is that you should be careful to design the database so that it supports the intended applications that will access the data within.

Optimized Servers

The final myth suggests that an optimized server is the only thing that matters when it comes to database server performance. We’ve already seen that this is untrue. You must have a well-designed database running on that properly optimized server. However, there is still more that you must do. Even with the fasted servers on the planet and the best designed database, performance will be poor if the users’ network connections to the server are not well designed.

If you haven’t caught my hints so far, the three myths all have the same solution. You must treat your database server implementations as a system. The system includes the database, the user application and everything in between. This means that you must ensure acceptable performance at the server, at the client and on the network in between. If you approach performance form a systems mindset, you are far more likely to locate the real performance problem in any analysis scenario.

In future posts, I’ll help you explore different areas of this system. You’ll learn how to look for performance problems, how to resolve them and how to prevent them. Until then, put on those systems thinking hats and start analyzing your SQL Server solutions.

By: Tom Carpenter has been working in IT for almost 20 years and has been training since 1997. He has written several books on various certification technologies such as network infrastructure technologies as well as server administration, SQL server, and will soon be releasing a book on SharePoint. Tom has taught over 30,000 students and currently teaches Windows 7 administration courses, Server administration courses, and Microsoft SQL Server administration courses.