VMWare and Powershell

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

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

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...
ddlgen in Sybase

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...
SQL Saturday 47 Phoenix Session

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...
Quick Powershell script to clean up text file

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...
SQL Saturday in Phoenix

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

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...
Get a quick Idea of Space used for SQL

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...
Powershell: AD Groups

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