Browse by Tags

• Best Practices
• Design
• Development
• Normalization
• Requirements
• SQL Server
• Writing

• Normalization and How to Know When You Are Done… The short version…

  A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in Read More... Posted Sunday, May 29, 2011 4:54 PM by drsql | 2 Comments Filed under: Database Design, Design, Development, Normalization, SQL Server, Terminology, Writing

• What is a physical database?

  A bit of terminology that gets beaten to death is that of the “physical” database.  I would think most every DBA uses this term (I do), but…to mean what?  I think there are two common utilizations: The layer of tables, constraints, indexes, Read More... Posted Thursday, June 11, 2009 6:26 PM by drsql | 4 Comments Filed under: Best Practices, Database Design, Design, Development, Requirements, Terminology, Writing