The Master Stored Procedure Workshop

Abstract:

Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? In a single day, we will show you how to write stored procedures from scratch, using the design advice we’ve accumulated in our combined 40 years of experience. Here are a few of the things you’ll learn: When and how to use stored procedures, The benefits and basics of contractual programming, How to write stored procedures from scratch, How to structure and organize stored procedures, Key techniques for ideal stored procedure management, Troubleshooting and debugging stored procedures. The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!

Speakers:

  • Sean McCown

    9 Recordings

    Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Recorded At:

Recorded on:

Aug 25, 2018

More Info:

http://www.sqlsaturday.com/794/Sessions/Details.aspx?sid=82970

Tags:

  • SQL 23 Recordings