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…