It is SQL (Structured Query Language) NOT SBQL (Structured Business Query Language) – Derik Whittaker

10 03 2009

It is SQL (Structured Query Language) NOT SBQL (Structured Business Query Language)

http://devlicio.us/blogs/derik_whittaker/archive/2009/02/28/it-is-sql-structured-query-language-not-sbql-structured-business-query-language.aspx#

It’s a self-admitted rant but still good commentary of the dangers of hiding business logic inside of SQL Stored Procedures. Today another instance reared its ugly head as input validation thats was being performed inside of a proc failed due to an idiosyncracy of SQL (the LEN function excludes trailing whitespaces but includes leading ones).

Often I hear/see the performance versus maintenance argument being thrown around when considering the placement of business logic inside of the SQL domain. That is a strawman argument at best. Performance is the least expensive upgrade option. How much does a new bleeding-edge server cost? How much does a senior development resource cost?

Posted via web from antFarm

Advertisements