The Multifunctioning DBA:



October 29, 2009  8:00 PM

Windows 7

Posted by: Colin Smith
Media, Media Streaming, Microsoft Windows, Windows

I have played with one of the preview releases and I liked it just fine. I just read some good info on Engadget that leads me to believe that I will like Windows 7 just because of the media center upgrades that have been done. I...

September 24, 2009  4:13 PM

Powershell Remove files

Posted by: Colin Smith
Microsoft Windows, Powershell, Windows, Windows Administration

I have a server that attempts to backup up the SQL Server databases and it always fails because not enough space is available. This usually is not a big deal as I would run a SQL Clean up task before the backups run to remove the old files. In this case though I am using a third party utility to...

July 23, 2009  9:43 PM

More with Quest AD Powershell CMDLETS

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

I am continuing work on the script that I am converting from VBScript to Powershell and I must say that it is going quite well with the help of the Quest cmdlets. In the script I want to go through a particular OU and delete any accounts that are currntly disabled, and were created a minimum of 180...

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

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 17, 2009  10:42 PM

File Copy with Powershell

Posted by: Colin Smith
Microsoft Windows, Powershell, Windows, Windows Administration

I have a friend that I work with that has to copy files out to the same 10 servers anytime our developers create a new report. To do this manually he has to log into the UNC of each server, verify that the server does not already have a report with the same name, if it does he needs to rename it,...

January 27, 2009  10:53 PM

Partitioning Tool

Posted by: Colin Smith
Windows, Windows Administration

I made a big mistake at home and only gave myself a 10 Gig partition of a 250Gig drive to be my boot drive. This was OK for a while but I did not manage the space well and before I knew it I was out of space and could not delete any more files. I found this great tool for home that is free for home...

January 27, 2009  8:52 PM

Disk Monitoring Q and A

Posted by: Colin Smith
Powershell, Windows, Windows Administration

Mike sent me an email asking about the input file for the disk monitoring script that I posted a while back. He could not get the script to work as he was putting the hostname and the IP of the machine in the computerlistall.txt file. The script was written to have either the hostname or the IP of...

January 21, 2009  5:25 PM

Powershell 2.0 CTP (Transactions)

Posted by: Colin Smith
Powershell, Windows

As I said I am just starting to fool around with Powershell V2.0 and I ran across a cmd-let that really grabbed my attention and I went to read more about it. This is a Fanatastic Idea and I am so excited to see Powershell use this in more Providers. Transactions, How cool is that? Just like...

January 20, 2009  5:49 PM

Environmental Variables in Powershell

Posted by: Colin Smith
Powershell, Windows

I have a script that I run in production that requires the script to access the Environment Variables for the server the script is executing on. This is a very simple task in powershell and very very useful. In my script I am using it just to verify that the machine name that it is executing on is...


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: