Sponsors

  • Microsoft
  • Nebula
  • Google
  • SugarCRM
  • Facebook
  • HP
  • Intel
  • Rackspace Hosting
  • WSO2
  • Alfresco
  • BlackBerry
  • CUBRID
  • Dell
  • eBay
  • Heroku
  • InfiniteGraph
  • JBoss
  • LeaseWeb
  • Liferay
  • Media Temple, Inc.
  • OpenShift
  • Oracle
  • Percona
  • Puppet Labs
  • Qualcomm Innovation Center, Inc.
  • Rentrak
  • Silicon Mechanics
  • SoftLayer Technologies, Inc.
  • SourceGear
  • Urban Airship
  • Vertica
  • VMware
  • (mt) Media Temple, Inc.

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Sponsor/Exhibitor Prospectus

Contact Us

View a complete list of OSCON contacts

Network
Join Attendee Network
 

Refactoring SQL

Jeremiah Peschka (Brent Ozar PLF)
4:10pm Thursday, 07/28/2011
Programming
 Location: Portland 255
Tags: database, sql, performance, performance_tuning, refactoring
Presentations: Refactoring SQL Presentation [BIN],
Refactoring SQL Presentation 1 [PDF]
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.

People planning to attend this session also want to see:

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.

Comments

Scott Baker
07/29/2011 9: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 4:46pm PDT

well presented, nice slides, entertaining, no new information

Scott Stevenson
07/28/2011 4:46pm PDT

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