design

Finding Tables for Employee Census Report

This is one of the posts where I describe the more technical aspects of a project I’ve been working on. The contents here are meant mainly to trigger my own memory when needed in the future.
The HR department has requested a census report so that the company can shop around for benefits with other [...]

Server-side processing rocks the house!

I’ve spent the last couple of weeks learning how to optimize the search tool we built. The short story is that we’re now using a pass-through query in Access to pass parameters to stored procedures on SQL Server. Processing time has gone from about 2 minutes to less than 2 seconds.
Now that I [...]

Every programmer should be on a testing project

I think every programmer should get a chance to be on a testing project because it will make him or her a better programmer. On one project I supported the complete software development lifecycle process to develop a multi-tiered, Intranet-based, Product Data Management System from a software quality assurance perspective. The company is [...]

In the UML Playground

A fellow developer and I are learning UML and VB.NET. We’ve decided to look at some of the existing applications the company is using from a UML perspective. We found a free version of Objecteering/UML Modeler and it looks like it will meet our needs so far.
I know there are lots of room [...]