Most have focussed on the business logic being in the database but the reverse is an equally troubling phenomena i.e. UI logic in the database. This ties the database to a particular UI and often a single viewpoint.

PS Even as a developer I sit in the "stored procedures are the default to use" camp.