On of the biggest challenges for web-based systems is the printed document. Our clients must be able to print out multi-page reports that are in a stable and clean format regardless of what machine downloads them, what browser they are using, and what printer is being used.
Using a stored procedure is the best way to interact with a database. I’ll use an example from the Dilithium Networks TCAN system (case.aspx).
A client had been posting training files and some order templates in an unmarked directory on their website. None of them are really all that secret, but some contact lists and other things got picked up by google.