call.copse (9/16/2014)
Ask a developer to use a stored procedure and majority will look at you as if you are mad.
Not really in my experience. Some are better than others, but it's not hard to include a few simple test cases for the edge scenarios in a proc, as well as spot checks against known test data.
You have been lucky then.
Agree, that they can be trained and test cases can be created etc. But there does have to be buy in. If the manger (pro MySQL/OpenSource) and director(semi technical) tend to say logic in the database is bad or business logic cant be done in the database then you are back to: ORMS Good, TSQL Bad.
Cant think of any business rules that I have come across that cant be done in tsql.