I recently was given the task as the 1st DBA at my company. It it one of those situations where I have the HUGE task of cleaning up after the years of bad practice. The first horror story I have is that everyone uses the 'sa' account to log in. I need to change this very quickly.
I checked out your article and it was helpful but my question is - how should I set up a system of users? Should there be a login for the developers or should each developer have their own login (of course I am talking about the development server)? I think it would be a huge pain to set up a whole system of logins for everyone in the production department.
How would you handle this situation?