SESSION Details

Fundamentals of Stored Procedures

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

Starts: 08:00 12th Mar 2022
Ends: 08:50 12th Mar 2022

Q&As

Short Description
- How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.

Slidedeck Link

Fundamentals_of_Stored_Procedures.zip

Speakers

Brent Ozar

Tags

Platform AgnosticDataOpsOperational DatabasesDevelopingDatabase EngineBeginnerHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.