In Defense of Surrogate Keys

Recently, I noticed a post on Planet MySQL expressing distaste for surrogate keys. Ever since reading it the topic has been bugging me so I thought I would finally break out a defense for surrogate keys. Really, it comes down to the right tool for the right job. Like The …