VMWare and Powershell
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...
0 Comments
RSS Feed
Email a friend
Powershell Rant
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...
0 Comments
RSS Feed
Email a friend
Testing
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...
0 Comments
RSS Feed
Email a friend
ddlgen in Sybase
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...
3 Comments
RSS Feed
Email a friend
SQL Saturday 47 Phoenix Session
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...
0 Comments
RSS Feed
Email a friend
Quick Powershell script to clean up text file
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...
0 Comments
RSS Feed
Email a friend
SQL Saturday in Phoenix
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
Useless Meetings
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...
0 Comments
RSS Feed
Email a friend
Get a quick Idea of Space used for SQL
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...
0 Comments
RSS Feed
Email a friend
Powershell: AD Groups
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...
0 Comments
RSS Feed
Email a friend
