The Multifunctioning DBA:


May 29, 2010  8:12 PM

Oracle OEM

Posted by: Colin Smith
DBA, Oracle

Today I needed to log into a Oracle instance using OEM to look at some users and roles. I found that when attempting to log into the instance with the sys username and password and as sysdba I was getting insuffcient privledges. Well I immediatley logged into the host machine and I was able to...

May 28, 2010  8:00 PM

Oracle on Windows

Posted by: Colin Smith
DBA, Oracle

I work in an environment that does use Sybase, Oracle, and SQL Server as the main RDBMS's. All of our Sybase and Oracle are running in Solaris Unix and or Linux. I just found out that I am about to have the opportunity to install and configure Oracle on a Windows Server 2003 R2 box. I am looking...

May 28, 2010  6:16 PM

Database Restores

Posted by: Colin Smith
DBA, Powershell, Recovery

In my environment we have a few instances where the customer would like to have a refresh done from Production to a test server. This is good for me since it gives me a chance to test my backups and make sure that they are good. It is good for the developers because then they are working witht the...

May 27, 2010  10:00 AM

Powershell Gui

Posted by: Colin Smith
DBA, Monitoring, Powershell

A while back, about a year ago, I wrote some custom scripts to monitor all of our SQL Server instances for errors. I have a driver file that has all the information that the script needs in order to find errors on the SQL Servers and it just walks thru them and checks for any errors that I might...

May 26, 2010  7:00 AM

Powershell to get unique login count from SQL Server

Posted by: Colin Smith
AD, Administration, DBA, Powershell, Reporting

Just like I needed to get a count of unique logins to an application on one of our Sybase instances I also needed to get these values for a few of our SQL Servers. Since SQL Server uses mixed mode authentication and we are using AD groups to aid in the security of the SQL Server, I could not just...

May 25, 2010  5:00 PM

Sybase SP_Who modified

Posted by: Colin Smith
DBA, Stored Procedures, Sybase

A while back I wrote a post about how I took a system stored Proc called SP_WHO and I modified it to only give me results for a certian subset of logins to the Sybase server. I let it run once an hour every hour for two weeks and then presented the numbers to my boss. He was very pleased that I was...

May 25, 2010  2:38 PM

SSAS Class

Posted by: Colin Smith
DBA, Education, SSAS, Training

I recently attended a deep dive bootcamp course in SQL Server Analysis Services. The class was geered more towards developers but it gave me a better understanding of what a cube is and how it works. The part that I was most interested in was the security portion and the 2008 version gives us a lot...

March 30, 2010  3:02 AM

Sybase 15 Upgrade Issues before the upgrade

Posted by: Colin Smith
Co-Workers, DBA, Politics, Sybase, Sybase 15, Upgrade

I have been working on a upgrade for one of our production systems from Sybase 12.5 to Sybase 15 for some time now. I, and my team, have done all the work from a DBA perspective to make sure that we are good to go for the upgrade. We have a system ready for testing and have provided connectivity...

March 12, 2010  5:28 PM

Phoenix SQL Saturday

Posted by: Colin Smith
DBA, MS SQL Server, PASS, SQL Saturday

Like I said in my last post, I attended my first users group and it was announced that a SQL Saturday is in the early planning stages. I am excited about this and since I am so excited I contacted Samson Loo, who is the one that made the anouncement, to see if I could help and also if I could post...

March 11, 2010  10:30 AM

Free Training

Posted by: Colin Smith
DBA, Education, Free, SQL Server, Training

Last week I came into work 2 hours early so I could be a part of a free all day training event. I am very glad that I did , but do not worry if you did not see it live. Since it was all web based you can get all the good content at your own pace. Check it out at

Bookmark and Share     0 Comments     RSS Feed     Email a friend

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: