The general idea one have about databases is that they only serve the purpose of storing plain values as numbers, dates and text. A database does not do just that but even more allowing you to store a whole file as an Excel spreadsheet or an MP3 file in a column you define in your table. This post s...

Syed Ali discussed stored procedures and why use them. I posted my comments there but thought it was worthy of an entry in the blog. There are some things I hate about them as well but I feel they have some very distinct advantages too so they are a necessary evil. I don't see how you can argue a...

I read Paul Nielsen post on stored procedure. According to him stored procedures are good for application. He is not only talking about logical or business process stored procedure, but he also encouraged to developer for CRUD stored procedures. I think, it is good idea. There is no harm to use them...