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 architecture angle. Typical Stored Procedures based application Typical application which heavily uses SPs for business logic may look like this. Most […]
Why Not to write SQL Stored Procedures – Part 1
Stored procedures (SPs) have been a workhorse for several decades. They have been used for many reason. Some of the 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 Performance. This is completely valid use of SPs. Fine […]