The Multifunctioning DBA:

Seperation of Roles


July 23, 2010  9:00 PM

EMERGENCY three times over

Posted by: Colin Smith
Emergency, Seperation of Roles

I got a call from a customer out of state that said they needed an emergency restore of a test database. I chuckled a bit and asked what made it such an emergency. I was told that they were attempting to do some testing and the database did not have the correct data in it and they needed to load it...

February 25, 2010  10:00 AM

Powershell Sysadmin Role Audit Script

Posted by: Colin Smith
Audit, Powershell, Seperation of Roles

I am working on a Powershell script that will audit my SQL Servers Logins and tell me who is a member of the sysadmin role. I think that this is a good idea for any DBA. I know that I do not want to have very many people with this type of access to data that I am in charge of protecting. This...

February 24, 2010  10:30 AM

Service Accounts with sysadmin role

Posted by: Colin Smith
Roles, Seperation of Roles, SQL Server

I have been finding so many servers that I have now that have application service accounts in the local administrators group. I HATE this. Why why why, do we not determine what the application needs and just give them that. I am only ranting about this because in SQL Server 2005 the local admin...

January 27, 2010  5:46 PM

DBA Roles

Posted by: Colin Smith
Developer DBA, MSSQL, Roles, Seperation of Roles, Systems DBA

I have a scenario that I would like to talk to you all about and get your take on what should be done. I am a Systems DBA. I am not a Developer. Lets say that in the not so distant past my team of System DBA's got a phone call from a developer in a panic. They needed a restore and needed it now....


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: