• As per Microsoft documentation, SQL was not intended as an object orientated programming language, it is a procedural system that stores and moves data.

    Even though the Microsoft employee, whose name you are comfortably not mentioning, is telling people not to use stored procs, Microsoft (documentation) still advocates that it is best practice and until they say otherwise, I'll use it.

    I feel that I have much more control over what is done and how objects are accessed inside a proc.

    As for the performance benefit I agree. Level of performance is decided by how you construct your query.

    There are pros and cons to maintaining procs. The biggest pro for me is when I have used them in my SSIS packages and a change to the SQL logic is easy without affecting the SSIS packages etc.