The Multifunctioning DBA:

July, 2011

July 29, 2011  3:43 PM

New meeting Place (FREE)

Posted by: Colin Smith
Free Tools, Meetings

I just found out and signed up for a new online meeting place. I have not tried it out but I am anxious to do so but it looks and sounds pretty nice and best of all it is free... Check it out at and I will give it a...

July 28, 2011  9:00 PM

Auditor Nightmare

Posted by: Colin Smith

My company has an audit coming up and I saw this post and thought I should take a look since we are getting ready for our audit. So take a look and let me know what you think about this.

July 28, 2011  3:44 PM

Spotify Review

Posted by: Colin Smith
Invite, Music, Spotify, Streaming

not to long ago I did a post about Spotify and gave you a link to go get an invite. well since then I have been playing with the service a bit, just on my PC, as I am...

July 27, 2011  3:20 PM

Finally a New Phone

Posted by: Colin Smith

I have had the Sprint HTC Hero for just about 2 years now and I loved the phone overall. Like any device it got old and slow and stopped getting updates. Once it got really bad about 6 months ago, I rooted and romed the phone and it came back to life. Sure I had some bugs and things were not...

July 27, 2011  8:00 AM

SQL Nexus

Posted by: Colin Smith
Tools, Troubleshooting

I use SQL Nexus all the time to identify bottlenecks of my SQL Servers and I absolutely love the tool. I ran into a small issue though where I could not always load the *.trc files. It would start and fail very quickly and move on to importing the other...

July 26, 2011  7:00 PM

T-SQL cursor to kill all spids connected by same program

Posted by: Colin Smith

I was recently asked by one of the application teams to come up with a way to kill all spids associated with a particular application once a day. Well I am not a t-sql guru by any means so I took this as a challenge and for once I did not pull out powershell but decided to go with T-SQL. With power...

July 26, 2011  5:45 PM

SQLSkills Training

Posted by: Colin Smith
SQLSkills, Training

Just got my reminder from the hotel about my stay starting this Sunday for the SQLSkills immersion event. I am very excited for this and can not wait to get there. I have a lot going on at the office and I think that this training will help me better deal with some of what I have going on. Also...

July 21, 2011  10:17 PM

Free SQL Server Training every week

Posted by: Colin Smith
Free, SQL Server, Training

BrentOzarPLF is has started a new thing that they are calling Technology Triage Tuesdays. This is great and the first one is online at These guys are great and I thank them...

July 15, 2011  4:59 PM

Spotify Invite

Posted by: Colin Smith
Music, Spotify

Spotify is a music streaming service that has been around in the UK for a while now but it just launched in the US. right now you have to be invited to Spotify to get a free membership. Currently Spotify has an invite only free streaming service and you can get your invite at this link:

July 12, 2011  10:28 PM

Netflix Price Changes

Posted by: Colin Smith
Netflix, Prices

Just saw that Netflix is increasing the prices. For me this means that I will drop my disks all together and just do the streaming for $7.99 a month. I dropped cable in order to save money not just to ship it all over to Netflix. So now I will just use Redbox and or Blockbuster or Vudu when I need...

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: