The Multifunctioning DBA:

April, 2011


April 30, 2011  8:00 PM

Vendors and Ridiculousness

Colin Smith Colin Smith Profile: Colin Smith

Ever have a vendor call and tell you that the database instance is the reason the app is not running correctly or very slowly? I did. They were installing an application and called me 7 hours into the install process to tell me that something was occurring on my database instance that was...

April 30, 2011  10:00 AM

Devs vs the DBA

Colin Smith Colin Smith Profile: Colin Smith

I am not a developer and I do not want to be and I know that developers have a job to get done but..... Why is it that developers want to have elevated privileges in production?? That one I think I can answer at least partly.. From my experience it is because they want to test code in...


April 29, 2011  8:01 PM

SQL Server Backups and who is responsible?

Colin Smith Colin Smith Profile: Colin Smith

Do you use a third party backup utility? If you do are you in charge of the tool and the infrastructure that it sits on? Well if you do then you are lucky. As a DBA I think that my first priority is to make sure that I have backups and backups that can be recovered of all of my Databases,...


April 29, 2011  4:12 PM

Powershell Data Sets

Colin Smith Colin Smith Profile: Colin Smith

Yesterday I got a call from a coworker who was having an issue with a script. He was looking to get some properties from an object and check the values. The problem is that the properties that he was checking also happened to be a collection of objects. So the problem he was having is that you can...


April 26, 2011  9:15 PM

Use Sony Network??

Colin Smith Colin Smith Profile: Colin Smith

Yet another breach of security. This time it is the Sony Network. If you use a PS3 and play games or use it for video or other services keep an eye out. Good article about it here.


April 22, 2011  10:00 AM

PASS Summit Abstract

Colin Smith Colin Smith Profile: Colin Smith

Today I finished my abstract for my "Powershell for the DBA" session for the PASS Summit. I am very hopeful that I will get the opportunity to speak at Summit as I will not be attending this year if I am not. Also presenting is a lot of fun and I would love to speak at a larger forum. This session...


April 21, 2011  9:14 PM

SQL Saturday Session Feedback

Colin Smith Colin Smith Profile: Colin Smith

I got back from Vacation a couple days ago and in my mail box was the feedback forms from SQLSaturday #73 Orange County. I had just under 30 people in my session and I did not get any where near that amount of forms but I am thankful for the ones that I did get. From the ones that I got back I only...


April 13, 2011  10:00 AM

SQL Saturday Slide Decks and Scripts Posted

Colin Smith Colin Smith Profile: Colin Smith

All of my slides and the scripts for my "Powershell for the DBA" presentation are up at the SQL Saturday #73 site. Link Below. http://www.sqlsaturday.com/viewsession.aspx?sat=73&sessionid=3963 Please...


April 12, 2011  5:10 PM

SQL Saturday #73 was a Success

Colin Smith Colin Smith Profile: Colin Smith

SQL Saturday is now complete and in my mind it was a success. I was not able to attend the full event so I can not do a full review of the day but I can speak to the parts that I was able to attend. It was not much but it was fun. I flew in to Orange County at 11:20AM and got a cab to take me to...


April 8, 2011  9:30 PM

Speaking about SQL Server

Colin Smith Colin Smith Profile: Colin Smith

I just ran across a great Blog post by Jen McCown (Blog | Twitter) about breaking into speaking. Speaking is something that I...


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: