Where Do We Put Business Rules? I received a number of replies regarding this question. Frankly, I’m surprised with the consistency of the responses. The overwhelming response to this point has been, “Put your business logic in the database.” Primarily, the recommendations are to put the logic into Referential Integrity, metadata enforced by stored procedures, or logic in the stored […]
Author: Ben Taylor
Where Do Business Rules Belong?
Where Do Business Rules Belong? I received a response to a reader’s comments from yesterdays Editorial. The original reader felt that implementing business rules in a database through the use of stored procedures and/or triggers was a bad thing. The server could not scale. Today our comment comes from Jeffrey. Jeffrey points out operational and deployment benefits of maintaining rules […]
Where Do Business Rules Belong?
Where Do Business Rules Belong? I received a response to a reader’s comments from yesterdays Editorial. The original reader felt that implementing business rules in a database through the use of stored procedures and/or triggers was a bad thing. The server could not scale. Today our comment comes from Jeffrey. Jeffrey points out operational and deployment benefits of maintaining rules […]
TOP (10) Worst Things to Do in a Database
TOP (10) Worst Things to Do in a Database The top ten list is finally here. Thanks to all your votes, (I know only three votes was hard), I have the final tally. Our top 10 list is: Count Down Database Actions to Avoid Individual Votes 10 Compensating for Bad Schema 19 9 Poor Clustered and Non Clustered Indexes 19 […]
TOP (10) Worst Things to Do in a Database
TOP (10) Worst Things to Do in a Database The top ten list is finally here. Thanks to all your votes, (I know only three votes was hard), I have the final tally. Our top 10 list is: Count Down Database Actions to Avoid Individual Votes 10 Compensating for Bad Schema 19 9 Poor Clustered and Non Clustered Indexes 19 […]
Integrating BLOB Data With Normalized Data
SelecTViews With Stephen Wynkoop Ryan Adams joins the show today, also information about disaster recovery and planning. Additional information on recent news, the SQL Server tip of the day and much more. [Watch the Show] Integrating BLOB Data With Normalized Data As promised…we are moving on today from the topic of database normalization from the editor’s perspective. I will be […]
Integrating BLOB Data With Normalized Data
SelecTViews With Stephen Wynkoop Ryan Adams joins the show today, also information about disaster recovery and planning. Additional information on recent news, the SQL Server tip of the day and much more. [Watch the Show] Integrating BLOB Data With Normalized Data As promised…we are moving on today from the topic of database normalization from the editor’s perspective. I will be […]
How Much Normalization is Enough?
How Much Normalization is Enough? I’m pretty sure you’ve already had enough of this topic as well. I have had a number of contacts from accidental DBAs and new developers in appreciation of the great lessons shared from real world problem solving. J writes in with an ERD (Entity Relationship Diagram) emphasizing how detailed you can get with your normalization. […]
How Much Normalization is Enough?
How Much Normalization is Enough? I’m pretty sure you’ve already had enough of this topic as well. I have had a number of contacts from accidental DBAs and new developers in appreciation of the great lessons shared from real world problem solving. J writes in with an ERD (Entity Relationship Diagram) emphasizing how detailed you can get with your normalization. […]
Data Normalization Again!
Data Normalization Again! I find it interesting that so many have written regarding the editorial yesterday. What I find most interesting is the respect shown by everyone to differing opinions. This is definitely an area that has a huge impact on many individuals, and I have seen discussion become personl to the point of a complete communication breakdown. My thanks […]