The Multifunctioning DBA:

January, 2009


January 31, 2009  8:20 PM

Powershell Tools

Colin Smith Colin Smith Profile: Colin Smith

Powershell V1.0 does not come with any tools to write scripts. Powershell V2.0 does come with a IDE but it is not as good as some of the other third party IDE's and V2.0 is still in CTP so you do not want to put it into production. Here are a couple links to a few that I have used and found to be...

January 30, 2009  6:01 PM

Powershell V2.0 CTP 3

Colin Smith Colin Smith Profile: Colin Smith

Powershell CTP 3 is out and ready to download and try on for size. I am downloading now and can not wait to get it installed and start playing around with it. I am looking forward to the release of V 2.0 and I really hope that they add actual useable remote functionality. I would like to have this...


January 28, 2009  8:29 PM

Powershell Explained

Colin Smith Colin Smith Profile: Colin Smith

If you are using Powershell but would like a better explanation of how it all actually works then here is a great video with Jeffery Snover and he explains things very nicely. Check it out and I hope that it will help you understand Powershell and even get even more into...


January 27, 2009  10:53 PM

Partitioning Tool

Colin Smith Colin Smith Profile: Colin Smith

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:58 PM

Learning SQL

Colin Smith Colin Smith Profile: Colin Smith

I have been a DBA for about a year now and I still have not had to really do much SQL. I do other things such as backups, restores, indexing, and other things to make sure that our databases are in good shape and that our data is safe. I thought it would be a great idea to learn some SQL though so...


January 27, 2009  8:52 PM

Disk Monitoring Q and A

Colin Smith Colin Smith Profile: Colin Smith

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 22, 2009  5:24 PM

Putty Connection Manager Tool

Colin Smith Colin Smith Profile: Colin Smith

If you are working in Unix or Linux you are most likely using some tool to connect via ssh to that server for your session. Putty is a free tool that manages this very nicely. Many of you are already using Putty I am sure. If you are I did find a Putty Connection Manager that is really very nice....


January 21, 2009  5:25 PM

Powershell 2.0 CTP (Transactions)

Colin Smith Colin Smith Profile: Colin Smith

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 21, 2009  4:48 PM

Powershell V2.0 CTP

Colin Smith Colin Smith Profile: Colin Smith

I finally got on the ball and downloaded Powershell V2.0 CTP and am starting to play with it now. You can download all that you need from http://www.microsoft.com/downloads/details.aspx?FamilyId=7C8051C2-9BFC-4C81-859D-0864979FA403&displaylang=en You will need to unistall Powershell Version 1...


January 20, 2009  5:49 PM

Environmental Variables in Powershell

Colin Smith Colin Smith Profile: Colin Smith

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: