SQL style guide
"Where possible avoid simply using id as the primary identifier for the table."<p>Has anyone had trouble by using surrogate primary keys?  I've found the opposite of what the author said could be more true: composite keys should be avoided instead.