Normalization is GOOD... most of the time.
Anyone who has known me for long enough knows while I love many things I.T. related, database design and efficiency is at the top of the list. I haven’t posted in far too long, but Becky Sweger, a fellow DB enthusiast and colleague at Wharton Computing, recently made a few posts that reminded me to update my own blog as well.
We recently had a blast collaborating on a presentation on database design. You can download our fun, but informative slides here:
Becky also has an excellent post here discussing some of the pitfalls of using SQL Server’s auto-generated code. This is very true for any flavor of database: you learn the true quirks of every database by hand scripting changes, and it is much safer as well.
Thanks Becky!