The Multifunctioning DBA:


May 29, 2009  2:41 PM

Powershell Plus

Posted by: Colin Smith
IDE, Powershell, Scripting, Systems Administration

I have been using PowerShell Plus for my PowerShell IDE. It is not free but I really think that it is the best IDE for PowerShell. They released version 3.0 not to long ago and it is even better. Along with the great code editor, debugger, and interactive window, they have added a learning center,...

April 30, 2009  9:15 PM

Powershell Ping (Cont)

Posted by: Colin Smith
Database, Database Administration, Monitoring, Ping, Powershell, SQL Server, System Administration

Earlier this month I posted about SQL Ping Servers Script that I was working on to notify different groups if a server was down or just SQL Server was down or just the agent was down. Well here is the next part....

April 24, 2009  4:15 PM

SQL Ping Servers Improved

Posted by: Colin Smith
Database Administration, DBA, Monitoring, Powershell, SQL Server, Windows Administration

Not long ago I did a post about pinging the interface of a server since you may encounter a problem connecting to WMI even if a server is up. The article is at

April 7, 2009  5:14 PM

Powershell Ping

Posted by: Colin Smith
Database Administration, DBA, Monitoring, Powershell, Windows Administration

I have a script that goes out and pings all of my SQL Servers. This script, right now, simply makes a connection to the SQL Server instance. If I am able to connect I call it good and if not I send out notifications saying that the SQL Server is down. I found that more often than not I was getting...

March 30, 2009  9:57 PM


Posted by: Colin Smith
Active Directory, Database Administration, Linux, Powershell, Scripting, System Administration, Unix, Windows, Windows Administration

So I have people ask me all the time how I can get so much done in a day. I have to be honest with you, I do not really do that much. This is because I write scripts to do anything and everything for me if I have to do it more than once I script it. If I think something...

March 26, 2009  5:20 PM

Free Space or Mount Points

Posted by: Colin Smith
Disk Space, Mount Point, Powershell, Windows Administration

I had a question about getting free space of mount points on a windows server. The user had some Exchange servers with a huge chunk of san disk attached. Then he mounted drive letters into empty folders on that disk. This gave him multiple mount points on that one volume. Now he wants to be able to...

March 18, 2009  7:58 PM

Powershell VS VBScript

Posted by: Colin Smith
Powershell, Scripting, VBScript

My wife works for a large company as an accountant for a company here in Phoenix and she called me one day asking if I could put a script together that would do some file manipulation and combine multiple files into one. I said no problem. You tell me what you need and I can do it in Powershell....

February 24, 2009  6:18 PM

Powershell commands for Active Directory

Posted by: Colin Smith
Active Directory, Powershell, Windows, Windows Administration

I have been asked how to manage Active Directory with Powershell. The best way is with the Quest Software cmd-lets for Active Directory. They are free and available at Once...

February 19, 2009  5:06 PM

Great Powershell Site

Posted by: Colin Smith

I ran across this site the other day and signed up. It has some great stuff and I have uploaded a couple of my powershell scripts to the site as well. If you love powershell like I do then you will check it out and sign up for a free account. Enjoy.

February 19, 2009  4:53 PM

AD Migration Script Q and A

Posted by: Colin Smith
Active Directory, Microsoft Windows, Powershell, Q and A, Windows Administration

I received a question from Sandeep as follows: Hi Colin, I saw your answer to one of the AD user creation question on IT Knowledge...

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: