Refactoring SQL

Location: Portland 255
Average rating: ***..
(3.27, 11 ratings)

Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency.

Photo of Jeremiah Peschka

Jeremiah Peschka

Brent Ozar PLF

Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.

I’m a consultant/manager/founder/owner/whatever with Brent Ozar PLF. We do database and storage consulting. We can talk about your architecture. We can help you plan to grow around your current infrastructure or help you build a new one.

I also enjoy writing descriptions about myself in the third person.

Comments on this page are now closed.


Scott Baker
07/29/2011 2:48am PDT

Best part of the presentation was the real world examples, but there weren’t enough. Speaker was engaging and interesting though.

Mark Deason
07/28/2011 9:46am PDT

well presented, nice slides, entertaining, no new information

Scott Stevenson
07/28/2011 9:46am PDT

Good info, I like the artsy slides. You gave me a few tricks to use.