So true. I've had sober senior developers argue that SPs are a dinosaur, they are hard to debug, you can do everything they do easier in business-layer code and LINQ queries, etc.
You effectively skewered most of that, especially about abstraction and separation of business/storage layer. VIEWs and SPs let DBAs change their minds (somewhat) about the details of storage, how data is extracted, etc. And, while people are touting the utility of "server-less" functions, SPs and SQL functions are the original version of that, pieces of logic that are tuned and optimized to run closer to the data ... where they belong.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
So true. I've had sober senior developers argue that SPs are a dinosaur, they are hard to debug, you can do everything they do easier in business-layer code and LINQ queries, etc.
You effectively skewered most of that, especially about abstraction and separation of business/storage layer. VIEWs and SPs let DBAs change their minds (somewhat) about the details of storage, how data is extracted, etc. And, while people are touting the utility of "server-less" functions, SPs and SQL functions are the original version of that, pieces of logic that are tuned and optimized to run closer to the data ... where they belong.