The Multifunctioning DBA:

May, 2009


May 29, 2009  10:01 PM

Oracle Upgrade Final Test this weekend



Posted by: Colin Smith
Database, Database Administration, DBA, Oracle, Oracle Upgrade

The Oracle 9 to 10GR2 upgrade that I completed last week will be getting its final test on Sunday. We will be failing over to our standby server and see what happens. I am not worried about this as all the files that are associated with the upgrade are on disk that is shared between the two cluster...

May 29, 2009  9:58 PM

Exchange and Powershell



Posted by: Colin Smith
Exchange, Exchange Management, Exchange Scripting, Powershell, Scripting

I was just asked to take a look at writing a script for our new Exchange environment. Now I do not have a lot of experiance scripting for Exchange but I love a Powershell challenge. The problem was that all of our distribution groups had been set up with one option incorrect. I was asked if I could...


May 29, 2009  3:02 PM

Love the Internet



Posted by: Colin Smith
Fun, Internet, Shopping

I love the internet. I really do, I mean I do not know how I lived without it. The internet makes so many things possible. I am good at my job and I am a smart guy, but I do not know how IT people did it before the internet. I Google and search online for so many issues that I have never seen...


May 29, 2009  2:56 PM

Notepad style editor



Posted by: Colin Smith
Editors, Managment, Scripting, Systems Managment, Tools

We all like notepad since it is quick easy and very lightweight. But what if it just does not do all that you want? Well I have used programs like Ultra Edit and I love it. The downside is that it is not as lightweight, you have to buy it, and the intallation is a pain. Great App and it does just...


May 29, 2009  2:49 PM

Powershell SQL Load Script



Posted by: Colin Smith
Database Administration, MSSQL, Powershell, Scripting, SQL

In my environment we have some servers, test servers, that are loaded from the Production Servers on a regular basis. Since this is the case I have decided that I would like to attempt to script this. I just started but I am already well on my way to getting this done. I am pretty sure that I will...


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


May 29, 2009  2:36 PM

SQL Server Certs



Posted by: Colin Smith
Certifications, Education, MS SQL, SQL, SQL Server

I have been talking about what I would like to do to further my education and my carreer as a DBA. I started reading the books in order to study for my MCITP DBA certification and the other members of my team decided that they would like to do the same. They both ordered the books as well and now...


May 20, 2009  4:32 PM

Iris Pen



Posted by: Colin Smith
Education, Scanner, Study

My wife is still in school and she wanted a way to scan lines from her book into some application in order to print notecards. She found the solution and it works really well. Thought I would pass it along to you all. It is called the Iris...


May 20, 2009  4:27 PM

Oracle Upgrade Complete



Posted by: Colin Smith
Database, Database Administration, Oracle, Upgrade

Last Sunday morning I came in to work at just after 2:00 AM and did the upgrade on our Production Oracle system. Since I had done this a few times on our test system I was ready for anything to happen. I had already installed the new version of Oracle and so I brought the DB Down changed my...


May 20, 2009  4:26 PM

Wii Game



Posted by: Colin Smith
Fun, Games, Nintendo

Yesterday on my way home I stopped and picked up the new Punchout Game for the Nintendo Wii. I was a huge fan of Mike Tysons Punchout on the regular NES so I was pretty happy to see Punchout come to the Wii. I did not know that you can use the balance board with this game as well. I thought that...


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: