I second Peter Midgley. Everything he said happens in our company too. 

We use a trigger based system. We track every time a row is add/deleted/changed by user and time...

While acknowledging the legal issues (and the law of unintended consequences politicians live by) I have to say that where ever possible the superior theoretical choice will always be developing...

I absolutely flat-out *love* my career, and have ever since that day in 1976 when I walked into our high-school's computer room (with stereotypical raised anti-static floor and frigid air-conditioning) for the...

Two words: Technical Debt

A basic tenet of development is the earlier you catch a problem, the cheaper it is to fix. In this case "architecture" means basic database...

Gotta say, as a one person IT shop Red Gate's tools (though expensive) are a god-send. They are literally the equivalent of having a second DBA!

Three tools in...

Failure in a test environment? That's why it's called *testing*. 🙂

There's a reason QA environments exist. The author's anecdote was a glaring example of why we have QA...

I used to use plural for tables, since a table is a collection--but that reasoning falls down somewhat when you actually consider what a table is.

A table is...

I'm a screen real estate junkie.

Give me a mid-range PC with maybe 8-16GB of RAM, a fast LAN and Internet connection, BUT I covet one of those...