Anith Sen Five Simple Database Design Errors You Should Avoid Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five... 16 October 2009 18 min read
Anith Sen Facts and Fallacies about First Normal Form When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith... 07 May 2009 15 min read
Joe Celko Unique Experiences! You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause... 18 November 2008 14 min read
Phil Factor Robyn Page Database Design Workbench – Keys Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh... 19 September 2008 18 min read
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
Louis Davidson Ten Common Database Design Mistakes If database design is done right, then the development, deployment and subsequent performance in production will give little trouble. A... 26 February 2007 32 min read
Arthur Fuller Database Design: A Point in Time Architecture In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However,... 22 February 2007 19 min read
Tim Gorman Bad CaRMa From hope and euphoria, to desperation, firings and the ultimate demise of a company. Tim Gorman charts the rise and... 16 October 2006 33 min read
Grant Fritchey SQL Server Performance Testing When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound... 15 May 2006 2 min read
Arthur Fuller Intelligent Database Design Using Hash Keys Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or... 17 February 2006 5 min read
Douglas Reilly Geek of the Week – Rebecca Riordan Rebecca Riordan has written several books on database design, and understands how to present data for both the database and... 08 June 2005 9 min read
