The Multifunctioning DBA:



July 27, 2010  8:36 PM

IT Audit

Posted by: Colin Smith
Audit, DBA, Roles

Recently my company went through an internal audit of our financial systems. First let me say that I am proud because we did well and do not have many issues to resolve, and no issues on the Database Side. Any way I also want to point out that the auditors are not IT people. They are accountants...

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

July 30, 2009  3:17 PM

Add a AD Group to MSSQL Server and add to a role using Powershell

Posted by: Colin Smith
Database Administration, DBA, Groups, Powershell, Roles, SQL Server

In SQL Server 2005 the Builtin Administrators group is a login, by default, to your MSSQL Server Instance and is also a member of the sysadmin role. Well this has been changed in SQL Server 2008 with good reason. I decided that I would like to add a group for my DBA Group to every SQL Server in...


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: