Home > IT Blogs > The Multifunctioning DBA/

The Multifunctioning DBA:

Seperation of Roles

1
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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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....

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1