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...

SOA Challenges: Entity Aggregation

Ramkumar Kothandaraman has a good article just released on MSDN discussing SOA Challenges: Entity Aggregation . Aggregation is a much better name than “composable entities“ since it's definition implies that property sets of an entity grow Read More...