The Multifunctioning DBA:

April, 2010

April 30, 2010  6:00 PM

VMWare and Powershell

Colin Smith Colin Smith Profile: Colin Smith

The other day I was asked to put a script together to disable all the backup nics that we have installed on a set of Virtual machines. This was cool for me as I had not done anything with VMWare in Powershell. I went out and downloaded the VMWare Powershell tools and I was on my way. Here is what I...

April 30, 2010  10:00 AM

Powershell Rant

Colin Smith Colin Smith Profile: Colin Smith

As you all know I am a big fan of Powershell and I think that it is a great language. I do not think that it is the best or only language that an Admin should know. I think that it depends on your job and what you are attempting to accomplish. I think that if you do most of your work in a unix...

April 29, 2010  11:00 PM


Colin Smith Colin Smith Profile: Colin Smith

I have just set up a test environment using virtualbox by Sun. this is a free Vitualization platform. I created two VM's that are both running Server 2008 and SQL Server 2008. I will use this setup to test things like mirroring, replication, and just other generall testing. I am sure I will be...

April 29, 2010  9:32 PM

ddlgen in Sybase

Colin Smith Colin Smith Profile: Colin Smith

I completed an upgrade from Sybase 12.5 to Sybase 15.0 recently and I found that it ended up breaking some scripts that we use to generate ddl for all instance devices and all create databases. The scripts that we were using were writting log ago by people that are no longer working for the...

April 21, 2010  3:51 PM

SQL Saturday 47 Phoenix Session

Colin Smith Colin Smith Profile: Colin Smith

Well I have done it now. After a Debate with a few people on twitter talking about whether or not Powershell is worth the time to learn I decided I would do a session about it. Why a DBA needs to know Powershell. It will be a basic 100 level session about what powershell is, how to install and...

April 19, 2010  8:12 PM

Quick Powershell script to clean up text file

Colin Smith Colin Smith Profile: Colin Smith

I had a script that was a list of user tables in a database. This was gathered from a sybase instance using the following simple sql query. select name from sysobjects where type = 'U' Simple enough but my output had blank lines between entries and this was no good. I needed to strip the...

April 19, 2010  4:50 PM

SQL Saturday in Phoenix

Colin Smith Colin Smith Profile: Colin Smith

I have posted this before, but I was asked to post about it again. SQL Saturday is a go for Phoenix. We have a date of July 17th at the 0 Comments     RSS Feed     Email a friend

April 15, 2010  10:00 AM

Useless Meetings

Colin Smith Colin Smith Profile: Colin Smith

So, today I have a two hour long meeting that is a new employee welcome meeting. I have worked for my company for about 6 years in all and I was moved over to the corporate team just under a year ago. Since the move to corporate I guess that makes me a new employee. I am OK with that, since I did...

April 13, 2010  5:50 PM

Get a quick Idea of Space used for SQL

Colin Smith Colin Smith Profile: Colin Smith

A couple weeks ago I had my SAN admin ask me about how much disk I would need to backup all of my sql instances to the SAN. Well I do not know that off the top of my head but I do have a list of all my instances and I know a little bit about powershell. So I decided to throw together a quick and...

April 13, 2010  5:00 PM

Powershell: AD Groups

Colin Smith Colin Smith Profile: Colin Smith

Two weeks ago was part of implementing a large upgrade in one of our Sybase environments. In order for this upgrade to be succesful we had to do some work in some AD groups. We needed to find all the users that would need to be a member of the new group that we were creating and take them out of...

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: