The Multifunctioning DBA:

February, 2009

February 27, 2009  2:34 PM

Oracle Upgrade

Posted by: Colin Smith
Database, Database Administration, Oracle

I did my Oracle upgraded yesterday and overall I think that it went pretty well. We are still testing but so far so good. The process was not too bad. First you need to create a new $ORACLE_HOME as two Oracle installations can not be in the same $ORACLE_HOME. Then install the media. I did run into...

February 27, 2009  2:26 PM


Posted by: Colin Smith
Economy, Jobs

A couple weeks ago I had mentioned that my company was forcing all of us to take unpaid time off work. Well I have an interview today. Sounds like a good place to work and it is in the Medical field so I am very excited about it. I think the Medical field is a great place to be in this type of...

February 25, 2009  4:58 PM

Oracle Upgrade

Posted by: Colin Smith
Database, Database Administration, Oracle

It looks like I might get the chance to upgrade one of our Test oracle systems today. I will be moving from 9.2.0 to 10.2. This should be interesting as I am still pretty new to Unix and to Oracle. I am looking forward to this and it really looks pretty straight forward. Looks like I will have to...

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 20, 2009  9:20 PM

Sybase Kill Runaway Process

Posted by: Colin Smith
SQL, Sybase

I am working on a stored proc that will be launched by a threshold that I set up on the log segment of my databases. It is a bit of work but I think that it will be nice not to get the page that someone has written some poor SQL and is filling up the log segment. I will not be running this in...

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

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

February 5, 2009  5:06 PM

Sybase 15 Driver Q and A

Posted by: Colin Smith
Database, DBA, Sybase

From my post about my company migrating one instance to ASE 15 I had the following Question as a comment.

February 5, 2009  4:57 PM

GP Question and Answer

Posted by: Colin Smith
Group Policy, Microsoft Windows, Windows Administration

Satish wrote me the following question: Hi, I would like to know that, is there any way that we ( as a normal domain user with out any admin privileges )logon to a desktop which has been added to a domain and then manage to do admin tasks like changing time ,or editing grouppolicy on the local...

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: