The Multifunctioning DBA:

Database


July 24, 2009  3:47 PM

Another New Language



Posted by: Colin Smith
Database Administration, DBA, Education, Monitoring, Perl, Scripting

My team is going to be developing a new application that will handle all of our monitoring. Currently that includes the monitoring of Sybase Servers, Oracle Instances, and MSSQL Servers. We will also be adding another Database Type that will house all of the Monitoring data. We will be using a...

July 17, 2009  3:59 PM

Update sysindexes table in Sybase 12.5.4



Posted by: Colin Smith
Database Administration, DBA, Sybase, Update System Tables

I am moving a Sybase instance from one host to another. I have done all the installation and patching and I have loaded all the databases with little to no issues. I ran into a big issue when attempting to change to indexes in sysservers to allow duplicate rows. I had to go and find out what the...


July 17, 2009  2:56 PM

MR. Denny has a webcast



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

I just saw this and I am looking forward to attending. MR. Denny is a great SQL Resource and I am sure that I will learn new things during this webcast. Here is a link to his blog entry about the...


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


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


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: