The Multifunctioning DBA:

May, 2010


May 30, 2010  7:00 AM

Happy Memorial Day

Colin Smith Colin Smith Profile: Colin Smith

Well it is the Holiday and I hope that if you are checking on this blog it is only because you are at home and have nothing better to do. (OUCH, I am sure that you do) I hope that you all have had a great weekend and I hope that this third day of the weekend treats you great as well. Be safe and...

May 29, 2010  8:12 PM

Oracle OEM

Colin Smith Colin Smith Profile: Colin Smith

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 29, 2010  7:00 AM

Andriod Update

Colin Smith Colin Smith Profile: Colin Smith

So I have had my HTC Hero from Sprint since the day it was released and I love it. It is a great phone and the Andriod OS is great and HTC did a good job adding some features. My biggest complaint has been that Sprint would not allow the phone to be updated to newer versions of the OS.  Well a...


May 28, 2010  8:00 PM

Oracle on Windows

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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  5:00 PM

Technet and why I love it

Colin Smith Colin Smith Profile: Colin Smith

Not long ago I decided to purchase a Technet Subscription from MS. This is one of the best things that I ever did. I get pretty much unlimited access to all MS products and I get to try them all out. I do not get to use the products in production of course, but for learning this is the best. I use...


May 26, 2010  7:00 AM

Powershell to get unique login count from SQL Server

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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


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: