Category: sqlserverpedia-syndication

SQL Saturday #56 – The 24 hour Challenge

SQL Saturday #56, Dallas BI edition, is tomorrow. Last night before the NTSSUG meeting, we had an unusually high number of SQLSat speakers unexpectedly drop out. The other UG board members and event planners are already up to their eyeballs in sessions (Sean’s giving three tomorrow!), so I was asked to put something together. In about 24 […]

Ground Zero Database Design: Part 2

Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that I could leave the subject alone for a while. Then I went looking through my blog ideas folder, and found this: DB design note:A column must mean what it means always, not just in steps […]

Ground Zero Database Design

All the SQL world should take database modeling classes, and thrive in the light of well-designed data structures. Back in the real world, though, an awful lot of folk who model DBs  – or just add new database objects – miss, forget, or ignore basic normalization principles. For your consideration, Ground Zero Database Design guidelines: […]