Sharing not a new topic, but this is an important question for all Database Professional and Software Architecture. Almost every Database Professionals had faced the same discussion on their company that which one is a better either Stored Procedure or Inline Ad Hoc SQL. As a Database Architecture, I suggest using only Stored Procedure. I … Continue reading Database Design: Use Stored Procedure, Do not use Inline or Ad Hoc SQL