I want to talk about some best practices concerning naming conventions. Most teams or organizations will come up with their own naming conventions for things. This post is not here to tell anyone how to define their naming conventions, especially for things outside of SQL Server. I want to talk specifically about things inside the…
Tag: Design
Stop Bad Database Design
Every year that goes by I sit in hope that I won’t see bad database design. Every year I am disappointed. As an example here is a table create statement that I saw the other day (table and column names have been changed to protect the innocent) (more…)
Please Don’t Use Deprecated Data Types
I know that a lot of vendors like to write for the lowest common denominator (i.e. SQL 2000) but really folks it’s gone too far. I’m sick of cracking open vendor code that’s certified for SQL 2008 and seeing things like IMAGE and TEXT data types. Microsoft deprecated these things back when they released SQL…