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

Layered Design and DataSets for Dummies

Scott Hanselman does a nice 30 second intro into layered design. If any of this is new to you, run quickly to read this . Scott does a quick bash at Datasets (although doesn't say why) and in my new role as DataSet boy I have to disagree with him and Read More...

Datasets vs. Custom Entities

So you want to build your own entity objects? Maybe you are even purchasing or authoring a code-gen tool to do it for you. I like to use Datasets when possible and people ask why I like them so much. To be fair, I'll write a list of reasons to not use Read More...

Where is the holistic vision?

Microsoft is needs a holistic view of their platforms and development tools. I didn't see that this week, I doubt any of us will. What I did see was 7 data access techniques in various stages of ready now, coming soon, and coming much later: Use a DataAdapter Read More...