Tag Archives: database design

The Cost of Architecture

Posted on October 24, 2011 by way0utwest

I saw a note recently about the cost of decisions in programming made over time (thanks to BrentOzar, PLF). It’s an interesting look back at what decisions might have ended up costing computing a tremendous amount of pain and problems over time. It’s … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Cost of Architecture

DRI or No DRI?

Posted on July 14, 2011 by way0utwest

This editorial was originally published on Feb 19, 2006. We are reprinting pieces this week as Steve is traveling in the UK. There is a great debate going on in the forums about using PKs/FKs to enforce RI, in other … Continue reading →

Posted in Editorial | Tagged , | Comments Off on DRI or No DRI?

Archiving

Posted on June 20, 2011 by way0utwest

Not many database systems get designed with a well thought out archiving plan at the beginning of their lifecycle. In most cases that’s fine since few databases seem to gather enough data to require archiving, and if there is extra … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Archiving

Multi-tenant Architecture

Posted on January 14, 2011 by way0utwest

When you design a database, or at least when I do, I think it’s important to build a database schema that is flexible, and anticipates change. You can’t foresee every change required, but you can consider the types of changes … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Multi-tenant Architecture