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

Actions

Information

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: