Previous part talked about why using Stored Procedures for writing business logic may be a bad idea. In this part, we continue on this subject but are going to look at the problem from an architecture angle. Typical Stored Procedures based application Typical application which heavily uses SPs for business logic may look like this. […]
Why Not to write SQL Stored Procedures – Part 1
SQL Stored Procedures (SPs) have been a workhorse for several decades. They have been used for many reason. Some of which can be justified, but some can lead to tremendous technical debt. The good of Stored Procedures Among justifiable reasons to write SPs are the following: The ugly of Stored Procedures SQL Syntax The worst […]