A few years back, I worked at a web development shop that had a problem. The web application servers kept intermittently crashing. It was traced back to the connection between the application servers and the database.
Upon review, it became clear that the cause was the occasional poorly written database operation. Our team of web developers were talented with client-side code and business logic but were not DBAs. The solution was the dreaded stored procedure rule: all SQL had to ...