A couple of weeks ago a customer couldn't create an SQL login account because it had a duplicate SID with an existing account (I have no idea how that happened). I followed Microsoft's directions to identify and delete the offending account.
Someday, I would like to take Test Out's SQL course or CBT Nuggets' SQL course.
