Anybody can write a stored procedure with a little help from Google. This session is about how to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.

This fast-paced, all-demo session with Brent Ozar will NOT cover how to write a query, syntax, or performance tuning. This is about good best practices after you've written the first one - things like how to catch errors, how to pass in multiple values, how to debug without the debugger, and more.

In fifty minutes, we'll walk through the contents of a well-written stored procedure and explain why it looks the way it does. You'll leave with the contents of that exact stored procedure so you can use it as a starting template in your own company.

feedback link :
Presented by Brent Ozar at SQLBits 2022