Comment by Mark on "Does my company use SQL Server in a normal way?"

I'm not an experienced DBA. I know there are certainly companies who don't do it like that, but I don't have statistics.

But I'd personally favor creating some (stateless) API that does as many of the procedures as possible. For these reasons:

It's easy to scale stateless applications but hard to scale database.
It's probably a lot more convenient to write in the language of your choice than stored procedures.
(You can switch to another storage backend easily... But that's pretty rare.)

But that's just my personal view, leave a comment if you disagree.

(As for the validation of results you gety back: there are definitely libraries for that in various langauges.)

Search Hashnode