Refactoring Database Stored Procedures

by Riley Major | at MinneBar 14

We get it. Move fast and break things. Just ship it! But what's left a giant stored procedure with cursors, temp tables, and mystery calculations. It's a big black box that nobody wants to touch. Let's fix that. We'll open the lid on an example monolith and do major surgery. What's left will perform better, be easier to understand, encourage code reuse, and be easier to test.

(Code and process is designed for Microsoft SQL Server but concepts have wider applicability.)

Most recent materials: https://www.sqlsaturday.com/842/Sessions/Details.aspx?sid=90600

Other presentation materials: https://scribnasium.com/talks/

Intermediate

Riley Major

Riley Major is an Enterprise Architect based in the Twin Cities, MN metro area who enjoys collaborating with business leaders to design technical solutions and working with technology professionals to build them. He's been programming and designing databases since he was a kid and doing so professionally for 20 years. He has a special place in his heart for T-SQL in SQL Server and loves to share that enthusiasm.