When GUIDs Are Good

Certain Data Architects (Dratz!) will tell you that GUIDs are for miscreants, deviants and DB n00bz. Well, I'm inclined to disagree with that generalization and lay out when GUIDs make perfect sense, when they're improper and why people who use Identity (auto-incrementing) columns shouldn't be allowed to work with databases.