The Multifunctioning DBA:

Database Administration


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

DTS Migration to SQL Server 2008 SSIS



Posted by: Colin Smith
Database Administration, DBA, Installation, SQL Server

Today I had a developer ask about moving old DTS packages into SQL Server 2008 SSIS. This is our first real test SQL Server 2008 instance and we had never done this. He was attempting to use the Package Migration Wizard to move the package into SSIS. We installed the BI Visual Studio Components and...


April 23, 2009  2:25 AM

Oracle Upgrade Complete



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

I was able to finish up the Oracle Upgrade that I wanted to do today. First I removed the previous installation of Oracle 10 on the server. I then installed the software and all patches that I needed. I then changed my variables to reflect the new Oracle Home Directory that I wanted to use. After...


April 22, 2009  3:34 PM

Oracle Upgrade Testing Once Again



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

Today I will again embark on the journey that is Upgrading Oracle. This will be the third and final time that I do this on our test system in preparation to upgrade our Production Cluster that also has a DataGaurd Backup solution. I expect this process to take a about 4 hours including the removal...


April 21, 2009  9:06 PM

SQL Server Education



Posted by: Colin Smith
Database Administration, DBA, Education, SQL, SQL Server

In an earlier post I said that I was about to start reading some books from the advanced Sybase Training course. I have changed course since then and I have decided to move on with some SQL Server education instead. I have decided that I would like to get my MCITP: Database Administrator...


April 21, 2009  7:04 PM

The Security Battle



Posted by: Colin Smith
Database Administration, DBA, MS SQL, SQL Server

I just had a battle with some applications support team members about securing our data. We have a system that connects to a SQL Server backend, this system has been in place for over a year now and is about to get a major application update. When this system was first implemented management let...


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 31, 2009  4:36 PM

Perfstat Cron Jobs



Posted by: Colin Smith
Database, Database Administration, Oracle, Perstat, Statspack

Here is the update on changing the perfstat statspack job that I spoke of earlier. The question was how can I get statspacks to run every 15 minutes during OLTP and every 2 hours during batch. My thought is a Cron Job that will run the SQL for you. Just make a connection to the DB using SQLPLUS and...


March 31, 2009  3:57 PM

Sybase Learning Continued



Posted by: Colin Smith
Database, Database Administration, Education, Sybase

Today I came back into the office after having a week off. It is always hard to come back into the office but it is nice to get back into the swing of things as well. When I arrived I found some new Sybase books sitting on my desk. Now I know that my company is not going to send me to another class...


March 30, 2009  9:57 PM

Scripting



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


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: