Security, Misconceptions, and Hybrid Architectures
This is Part 5 of the “Where Does Business Logic Live?” series. We have made the , the , and the comparison. Three things remain before we can build a decision framework: how security actually…
Performance and Operations: Measuring Instead of Arguing
This is Part 4 of the “Where Does Business Logic Live?” series. Parts and made the principled cases for the database and the application tier. Principles are where these debates start; measurements are where they…
The Case for Business Logic in Application Layers
This is the third post in the “Where Does Business Logic Live?” series, and it is the deliberate mirror image of the last one. In I made the strongest case I could for putting data-centric…
The Case for Business Logic in Stored Procedures
This is the second post in the “Where Does Business Logic Live?” series. In I laid out the terms of the debate and split “business logic” into five different kinds of logic that behave very…
Where Does Business Logic Live? A DBA’s Field Guide
Ask three experienced engineers where business logic belongs and you will get four answers, two raised voices, and at least one person quoting a blog post from 2008. I have sat on both sides of…
Where Does Business Logic Live? A DBA’s Guide to the Stored-Procedures-vs-Application-Layers Debate
Few architecture questions generate more heat and less light than this one: should business logic live inside SQL Server stored procedures, or outside the database in application layers? Ask a room of developers and DBAs…