The Multifunctioning DBA:

April, 2009


April 30, 2009  9:15 PM

Powershell Ping (Cont)



Posted by: Colin Smith
Database, Database Administration, Monitoring, Ping, Powershell, SQL Server, System Administration

Earlier this month I posted about SQL Ping Servers Script that I was working on to notify different groups if a server was down or just SQL Server was down or just the agent was down. Well here is the next part....

April 29, 2009  9:26 PM

SQL Server Training Kit



Posted by: Colin Smith
Certifications, Education, MCITP: DBA, Training

I received my SQL Server 2005 Certification Training kit in the mail and have started on the first book. I am trying to do a chapter a day so that I will be able to take the test in a month or less. So far I have only done two chapters in two days but the book is not bad to read and has good...


April 29, 2009  7:27 PM

Error while installing SQL Server 2005 SP 3



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

I have installed SP3 on a few SQL Servers with no issue at all. The other day I go to install it on a production instance and it fails with the following error: A Recently Applied Update, KB955706, failed to install. The update failed with that error for the following services: Database...


April 28, 2009  10:15 PM

SQL Version Script



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

I needed a quick audit of some of the SQL Servers in my environment. We wanted to know what version and what SP each instance was running. I threw this together and it is pretty simple. It only checks for SQL Server 2000 SP4 and SQL Server 2005 RTM thru SP3.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


April 24, 2009  6:53 PM

MS Employee Comments on Blog



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

Yesterday I posted a blog about installing SQL Server 2008 SSIS DTS Package Migration Wizard. This can be found at http://itknowledgeexchange.techtarget.com/dba/dts-migration-to-sql-server-2008-ssis/....


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


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: