mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Year: 2011

Do you believe these 3 development tool myths?

Education*This post is from Brian Crowley, mrc’s Director of Development*

While at a recent tech conference, I had an interesting conversation with a long-time programmer. The programmer had apparently had some bad experiences with development tools, based on his views on the subject.

Frankly, nothing he said surprised me. I’d heard it all before. Most “anti-development tool” programmers usually cite the same reasons, and to be honest, I understand where they’re coming from. They’ve run into enough bad development tools in the past to form a pretty negative opinion of the whole lot. Their criticisms aren’t always accurate, and certainly don’t apply to ALL development tools, but I get why they feel that way.

Pivot table comparison: Excel v. Google v. Web-based

EducationPivot tables are great tools for spotting hidden details and trends in a sea of data. One pivot table lets you quickly examine nearly any aspect of your data. Also, unlike static reports, the user determines what parts of the data to analyze.

The big question with pivot tables is this: Which pivot table option is best for my company? Right now, there are three main pivot table options: Google Docs, MS Excel, and database-driven web pivot tables. How do they compare? We’ve put together a handy one-page guide which explains the differences between each pivot table option. I hope you find it useful.

A dirty little secret about screen-scraping

Save MoneySuppose you’re buying a new computer. You find a great-looking computer at a local store, bring it home, boot it up, and…it’s extremely slow. You open up the case only to discover that all of the internal parts are at least 10 years old. You storm back to the store demanding your money back because they sold you an old computer. Their response: “Of course it’s new, look at the new, beautiful case we put it in.”

Of course, that’s a ridiculous story. No self-respecting computer store would sell you a “new” computer that’s actually old on the inside. Why then, do some companies try to sell “modernization services” which do little more than put a flashy new case on old parts?

Turning COBOL programmers into web developers

Save MoneyBack in 1997, Gartner estimated that 80% of the world’s businesses ran on COBOL. These days, the numbers are a little more uncertain. Some say that number is down to 70%. I’ve also seen surveys that put it right around 62%. Regardless of the figures, one thing is clear: COBOL is still widely used in many businesses.

However, many of these businesses find themselves in a tough situation. They have their COBOL programmers on staff to maintain their current apps. But, they don’t have the skills necessary to build modern web apps, and can’t afford to bring in new employees. …

How application architecture can save time and money

Save TimeA few months into owning our first house, we learned something: The builder took some short-cuts. Unfortunately, you don’t recognize architectural defects when you buy the house. They become apparent after you’ve lived in it for some time.

Business applications are the same way.

If you’re building/buying new business apps, or buying software to build new business apps, be careful. It’s easy to fall in love with the interface and features without paying any attention to what really matters: The architecture. …

Meeting immovable deadlines

Save TimeDepending on which research firm you believe, anywhere from 50-90% of IT projects are completed late. While I could rattle off any number of reasons for this, I think that (much of the time) it boils down to one problem: Being late is an option. The deadline is viewed merely as a suggestion…it’s not the end of the world if it’s missed. We’ll just inform management that the project is running behind schedule and then set a new deadline.

But, what if being late wasn’t an option? …

Pivot tables in Google Docs: How do they compare?

EducationA couple of weeks ago, Google announced some big news: Google Docs now has pivot tables! I know what you’re thinking: How is this different than other pivot table options, such as those found in Excel? Are they right for business? I’d like to help you answer these questions.

First, how does this differ from other pivot table options? Before we answer that question, we must first answer this question: What are the other options? Before Google pivot tables came around, there were 2 main approaches to pivot tables: Excel pivot tables and database-driven web pivot tables (like those created with m-Power). With Google’s foray into pivot tables, we now have 3 legitimate pivot table options. So, which one is best for your business? The best way to answer that question is to take a look at how each option compares in 5 key areas: …

Create business reports in under 5 minutes

Save TimeSome people request them from the IT department. Others lock themselves in their offices for a day or two and go crazy with spreadsheets. Others delegate the task. Whatever the method, everyone has a process for creating business reports.

But, what if your process wastes time? What if the hours you spend running reports or analyzing data are unnecessary?

Here’s a good test: Does it take longer than 5 minutes? If so, you’re wasting time. Within a matter of seconds, you should be able to see any piece of data you wish to see. For example, applications like this interactive report or this web pivot table report give you a high level view of data, but let you “slice-and-dice” it however you want. …

Build 2 web apps in 45 minutes (without programming)

Save TimeCreating enterprise web applications doesn’t have to be difficult or time consuming. We’ve set up a free m-Power trial that will walk you through the process of developing enterprise level web applications without programming. The on-screen tour will guide you through the creation of a simple web application, and the whole process should only take about 5-10 minutes.

Get started right here>>

Why are so many IT departments outsourced?

Save MoneyDo you know why so many IT departments get outsourced? Because many businesses view IT as a service organization, existing only to support the business. They view IT as “order-takers,” not innovators. From their perspective, if the IT department exists only to take orders from the business, why not outsource?

I think that perception needs to change, and I’d like to show you how. …

Mobile applications: Why architecture matters

Save TimeA couple of months ago, I wrote up my thoughts on developing mobile applications for business. In short, I believe that creating web apps designed for mobile use makes more business sense than creating platform-specific applications. I’d like to go one step further and explain how this concept works from an architectural perspective.

First, you must understand n-Tier architecture. While this sounds like a complicated technical term, I assure you that it’s relatively simple and makes sense from a business perspective. In short, n-Tier architecture breaks an application up into separate layers, or tiers. Typically, there’s a presentation layer (what you see in the browser), an application layer (your business logic), and a database layer (data storage). …

How long should business software stay current?

Save MoneyI wrote up a post last week about avoiding software purchase failure. A commenter on that post made a great point: Software failure is sometimes caused by planned obsolescence–the deliberate planning of a product with limited useful life.

In other words, many software vendors realize that it’s in their best interest to create software that only stays relevant for a few years. If they create software that’s good enough to buy, but not good enough to last 10 years, you’ll buy more software and they’ll make more money. …

2 ways a portal will help business (and how to make one)

Save TimeA customer portal (or customer extranet) is a secure area of your website designed for your customers. They can log in and perform a number of different tasks, such as pay their bill, view their information, purchase new products, ask a question, etc… If your business has customers (and I hope that it does), you should really have a portal set up. Why? I could rattle off a number of reasons, but here are the two biggest ways a portal/extranet will help your business: …

4 reasons why software purchases fail

Save MoneyHave you ever been in a “blame” meeting? It’s one of those meetings called when numbers are down or after a project or purchase failed miserably. As you might guess, there’s a lot of finger pointing and blame spreading. Not only are these meetings painful, they are completely unproductive. Since everyone is too busy deflecting blame, no one learns from their mistakes.

I’d like to help you avoid these meetings. Obviously, I can’t write a definitive guide on how to avoid failure, as every business and situation is different. However, I can help you avoid failure in one area that applies to most companies: Software purchases. In my experience, software purchases usually fail for one of four reasons. I’d like to explain those reasons and then tell you how to avoid them. …