SelecTViews With Stephen Wynkoop Mongo for Windows Phone SDK available, SQL Injection in the Cloud, an Interview with Sherri McDonald about SSRS and training coming soon [Watch the Show] Compensating for Bad Schema – Triggers Triggers are a great asset to any DBA. They allow a database to react to modification of data through Insert, Update or Delete actions. They […]

Compensating for Bad Schema Most of the items from the bad things to do in a database survey were pretty straight forward. I find it interesting that the item receiving the most votes for bad things to do was also one of the items I received the most questions regarding it’s meaning, “Compensating for Bad Schema.” There are a number […]

MOCK Your GUI I love this caption. I’m sitting here picturing a developer looking at a screen someone designed and saying something like, "My 2 year old son could design something better than that with crayons." But that’s not where I’m going with this. In my experience, the most difficult piece of software to test is the User Interface. Graphical […]

SelecTViews WIth Stephen Wynkoop All the news of the day that counts is provided here.. also, find out about normalization, what types of skills might be good for specialization and upcoming learning events…We keep you informed and up to speed on tips tricks and more. [Watch the Show] What is a business rule really? Now we’re really getting down to […]

Business Rules and ETL As has been mentioned by others, a growing architecture is to put more business rules in a Business Layer, rather than simply relying on the database alone. A number of system requirements are driving this technique: The growth of NoSQL The growth of distributed SQL The growth of not always connected applications performing data synchronization Support […]

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] Where Do Business Rules Belong? Reader consensus Says In the Database Thanks to all of you for your input on this subject. Many have written […]

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 […]

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 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 […]

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 […]