15 October 2015

The Simple Truth

Up through my stint with CSC, SQL Server was a minor database in my trek. Once, even, the principal datastore. Along about then, I found simple-talk. Then, much of the discussion was driven by database design and development concerns. Celko was a frequent guest essayist.

In recent times, more of the essays have been couched in coder jargon. Sad.

One that's up on the front page, deals with continuous integration of databases. It's interesting, but what I found the j'accuse moment was this bit from a comment by rogerthat:
The worst times we've had with failing database builds were a result of using code first development (program design refactors database design, somewhat automagically). ... Experience leads us to design the database to handle the cited requirements while still keeping the database flexible (and no, this does not include unrealistic character data lengths).

While rogerthat doesn't use the N word, it's clear from the comment that normalization is the key. There is hope for humanity.

No comments: