Brent Ozar
brentozar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
SQLBits 2022
Fundamentals of Stored Procedures
How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.
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 : https://sqlb.it/?7065
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 : https://sqlb.it/?7065