The Multifunctioning DBA:


May 26, 2010  7:00 AM

Powershell to get unique login count from SQL Server

Posted by: Colin Smith
AD, Administration, DBA, Powershell, Reporting

Just like I needed to get a count of unique logins to an application on one of our Sybase instances I also needed to get these values for a few of our SQL Servers. Since SQL Server uses mixed mode authentication and we are using AD groups to aid in the security of the SQL Server, I could not just...

April 30, 2010  6:00 PM

VMWare and Powershell

Posted by: Colin Smith
Powershell, VMWare

The other day I was asked to put a script together to disable all the backup nics that we have installed on a set of Virtual machines. This was cool for me as I had not done anything with VMWare in Powershell. I went out and downloaded the VMWare Powershell tools and I was on my way. Here is what I...

April 30, 2010  10:00 AM

Powershell Rant

Posted by: Colin Smith
Powershell, Rant

As you all know I am a big fan of Powershell and I think that it is a great language. I do not think that it is the best or only language that an Admin should know. I think that it depends on your job and what you are attempting to accomplish. I think that if you do most of your work in a unix...

April 21, 2010  3:51 PM

SQL Saturday 47 Phoenix Session

Posted by: Colin Smith
Powershell, SQL Saturday, Training

Well I have done it now. After a Debate with a few people on twitter talking about whether or not Powershell is worth the time to learn I decided I would do a session about it. Why a DBA needs to know Powershell. It will be a basic 100 level session about what powershell is, how to install and...

April 19, 2010  8:12 PM

Quick Powershell script to clean up text file

Posted by: Colin Smith
File Admin, Powershell

I had a script that was a list of user tables in a database. This was gathered from a sybase instance using the following simple sql query. select name from sysobjects where type = 'U' Simple enough but my output had blank lines between entries and this was no good. I needed to strip the...

April 13, 2010  5:50 PM

Get a quick Idea of Space used for SQL

Posted by: Colin Smith
Database Size, Powershell, Scripting

A couple weeks ago I had my SAN admin ask me about how much disk I would need to backup all of my sql instances to the SAN. Well I do not know that off the top of my head but I do have a list of all my instances and I know a little bit about powershell. So I decided to throw together a quick and...

April 13, 2010  5:00 PM

Powershell: AD Groups

Posted by: Colin Smith
AD, Groups, Powershell

Two weeks ago was part of implementing a large upgrade in one of our Sybase environments. In order for this upgrade to be succesful we had to do some work in some AD groups. We needed to find all the users that would need to be a member of the new group that we were creating and take them out of...

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 8, 2010  7:19 PM

Find SQL Server Instances using Powershell

Posted by: Colin Smith
MS SQL Server, MSSQL Administration, MSSQL Instance, Powershell, Scripting

As I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...

January 6, 2010  10:33 PM

Lots of Work to be done

Posted by: Colin Smith
Clean Up, MS SQL, MS SQL Admin, Powershell, SQL Server

A few months ago I was transferred to my companies parent company. I think that this is good news for me so I am happy about it now. I have been asking, for about a month, to do a network scan in order to identify servers that have SQL installed. Due to the holidays and scheduling I did not get...

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: