Earlier today, I presented a session for Pragmatic Works Training on the T’s titled Necessary Evils, Building Optimized CRUD Procedures.  In the session, I discussed some of the issues surrounding the use of CRUD-based stored procedures and the applications that use them.  Providing a number of tips for identifying performance issues and resolving them.

The abstract for the sessions is:

Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance.

Webcast Recording & Materials

If you missed the webcast, you’ll be able to view the recording online by this Friday.  For those that want to download the slide deck and the scripts, you can click the following link –

Necessary-Evils-Building-Optimized-CRUD-Procedures.zip.

Also, if you just want to flip through the slide deck again, here you go.

Necessary Evils, Building Optimized CRUD Procedures from Jason Strate

Thanks for Attending

Thanks to those that attended the webcast.  Considering that I had the flu yesterday and was pretty dead to the world, I think the session went pretty well.  If you have any questions on the webcast or suggestions for improvements, please leave a comment on this post.