Tag Archives: Design

Database Design

One of the things I like best about working with computers is designing systems, whether that’s programs, databases, interfaces or all three and more. Lately I’ve been working primarily on databases and I thought I’d talk a little about database … Continue reading

Posted in Design | Tagged , | Leave a comment

Column Naming

When you’re designing your tables it is important to keep track of the names you’re using for the columns. Don’t just name the ID columns ID. Name them so you’ll know what table the ID belongs to. For example, if … Continue reading

Posted in 2008, SQL Server | Tagged , , | Leave a comment

Redundancy

There are certain types of redundancy that are good in the IT world: Backups, failover servers, recovery plans and the like. Most redundancy however, is bad. In the programming world, bad redundancy comes in the form of repeated code instead … Continue reading

Posted in 2008, Programming, SQL Server | Tagged , , , | Leave a comment