The Database Programmer

This week I am taking a bit of a departure. Normally I write about things I have already done, but this week I want to speculate a b...

No it does not. If it did, then your customer/employer would be doing something no other human being has ever done, which is unlik...

There are links to related essays on normalization and denormalization at the bottom of this post . This blog has two tables of contents, ...

The stunning power of a data dictionary comes into play once the dictionary contains formulas for calculated values. The dictionary ca...

When you set out to use a Data Dictionary to control your database upgrades, you must consider not just columns and tables, but also i...

The number one search term that brings people to this blog is "data dictionary." So this week I will begin a series on ho...

A normalized database stores each fact in exactly one place. This makes for very robust write operations, it is much easier to get thi...