October 2010
Mon Tue Wed Thu Fri Sat Sun
« Sep   Nov »
 123
45678910
11121314151617
18192021222324
25262728293031

Day October 1, 2010

Entries 2 Total

Upcoming Training – Columbus Code Camp

Oct 1, ’10 12:00 PM

Good news, central Ohio residents! I’m going to be speaking at the Columbus Code Camp. I’ll be joining some amazing speakers and I’m really excited to be speaking locally again.

Original photo (http://www.flickr.com/photos/jetalone/121048480/), some rights reserved (http://creativecommons.org/licenses/by/2.0/deed.en)

Proof that you can refactor anything

The best part is, this is a brand new talk. That’s right, Columbus, you get the brand new sexy! I’m going to be talking about Refactoring SQL Applications. Here’s the abstract:

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.

This isn’t going to be an in-depth dissertation. The purpose of the presentation is to lay a solid foundation that developers can use to build their own refactoring tools and techniques. This is the capstone of the last two years of my professional life and I’m really excited that I get to attempt to wad up what I learned, run it through a grinder, and the share it with the world in the form of Delicious SQL Sausage. Jimmy Dean would be so proud of me. So, if you’re in or around Columbus on October 16th, come and check out my talk. You can get more info at http://columbuscodecamp.com

Comments (2)

What I’ve Been Reading – 2010-10-01

Oct 1, ’10 9:00 AM

It’s been a technical week.

Exclusion constraints are generalized SQL UNIQUE One of the cool new features of PostgreSQL 9.0 is exclusion constraints. Exclusion constraints make it possible to create a scheduling grid for a classroom or hotel that prevents double bookings of a room.

Your Software Can Learn A Lot From ATMs ATMs are simple. They work. They work well. When they don’t work, they tell you that something is up, but they don’t do anything sneaky or have side effects or do two things at once. Do you want to take out money? Do you want a receipt? Do you want to deposit money? There aren’t multiple options with strange combinations. You do one things and then move on to the next. Your software should be like this.

Gurus and Bastards What’ll it be? Helpful optimistic guru or grumpy bastard?

Learn Python the Hard Way A fun new way to learn how to program: type the program, run the program, do the extra credit.

txn.commit() are you sure? Think about whether you’re really using those transactions the right way. Think about it.

Comments (0)

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 230 items have been purified.