9/4/2023 0 Comments Stand by me ten thumbs![]() ![]() Prophetic words for all parts of life and a description of the type of issues that plague many projects these days. “ If you don’t know where you are going, any road will take you there” – George Harrison Not using stored procedures to access data.Not using SQL facilities to protect data integrity.Using identity/guid columns as your only key.Hopefully, after reading this article, the little voice in your head will talk to you when you start to stray from what is right in terms of database design practices. When I speak, or when I write an article, I have to listen to that tiny little voice in my head that helps filter out my own bad habits, to make sure that I am teaching only the best practices. I used to have a preacher who made sure to tell us before some sermons that he was preaching to himself as much as he was to the congregation. And these aren’t exactly the same ten that I started with these are ten that stand out to me as of today.īefore I start with the list, let me be honest for a minute. Originally there were ten, then six, and today back to ten. ![]() I also presented a boiled down, ten-minute version at PASS for the Simple-Talk booth. If you’re interested in hearing the podcast version, visit Greg Low’s super-excellent SQL Down Under. People (myself included) do a lot of really stupid things, at times, in the name of “getting it done.” This list simply reflects the database design mistakes that are currently on my mind, or in some cases, constantly on my mind. No list of mistakes is ever going to be exhaustive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |