Category: Uncategorized

A friend wrote me (and a few others) today to get opinions. Edited for content/anonymity: I interviewed with one person (head of their office) who admitted he knows nothing about databases.  He asked me a few general questions, told me that my resume was really impressive and I seem to be very knowledgeable. I asked […]

I'm going to commit a huge breach of blogger etiquette today: I'm going to read to you (more or less) directly out of SQL Server Books Online.  Whether you haven't read these important parts, or just need a refresher, everyone should get back to the basics once in a while.  And we're gonna rock this Miss Lippy style! […]

There exist tutorials and large sections of many books devoted to all the principles that go into good table design. Today let's rattle off a quick summary of important points: Modeling – A table models something in the real world…either something tangible (like socks or beer) or not (like services or phone calls). Names – Table names […]