Browse by Tags

Are we still talking about Stored Procedures vs. Dynamic SQL?

Rob Howard and Frans Bouma still are. And I guess, I am now too. Let's summarize a few of the facts from these counter points: Any form of pre-compilation or cached query plan arguments are moot betweem SQL and Procs. Rob has some outdated information Read More...

When is a database oriented as a service?

Do you consider your database as a service? It's worthwhile to review the tenents of a service oriented architecture . The first two tenents above are probably the most relevant to my question. If you do all of your data access through stored procedures, Read More...