The Multifunctioning DBA:



July 28, 2011  9:00 PM

Auditor Nightmare

Posted by: Colin Smith

My company has an audit coming up and I saw this post and thought I should take a look since we are getting ready for our audit. So take a look and let me know what you think about this.

January 30, 2011  9:21 PM

Triggers for protection

Posted by: Colin Smith
Audit, DBA, MS SQL Admin

I have recently had to find a way to prevent someone that has elevated privileges from removing logins, databases, as well as keep them from adding new databases to my production systems. I was amazed at how easy this was to do thanks to event level ddl triggers. I created a table in master called...

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

January 22, 2010  1:12 PM

Health Check into SQL Server

Posted by: Colin Smith
Audit, Baselining, MSSQL, MSSQL Administration, Trending

I have recently posted about my new job and how I am walking into the unknown. Like I have said in the past, I did get a list of Host Names that are running SQL Server. I have written a script to go out and look at each of those hosts and get me all instances. I have put together a list of about...

September 18, 2009  4:37 PM

AD Audit in Powershell

Posted by: Colin Smith
AD, Administration, Audit, Automation, Powershell

I have mentioned this before but I have finally done what I set out to do and re-wrote my old vbscript that audits AD Accounts based on Create Date and Last LogonDate in Powershell. This is another great example of how much better powershell is and why everyone should now it. My VB Script was just...


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: