The Multifunctioning DBA:

November, 2011


November 29, 2011  5:35 PM

Powershell Gather Table Data

Colin Smith Colin Smith Profile: Colin Smith

I had a person on my team that wanted to identify tables in our enterprise that might be good candidates for compression. I thought it might help him out if I had a script that would look at every table in our enterprise that exists in a SQL Server database and give him some basic info that may...

November 29, 2011  10:00 AM

The Transformer

Colin Smith Colin Smith Profile: Colin Smith

I recently Ranted about my experience with trying to purchase the


November 28, 2011  5:22 PM

Amazon Sales Rant

Colin Smith Colin Smith Profile: Colin Smith

First, before I get into my rant I must say that I love Amazon and I think they are awesome overall and love the Black Friday, Cyber Monday lightning deals that they are doing but I do have one complaint. I Wanted to purchase the


November 25, 2011  9:00 PM

Another Index to save the day

Colin Smith Colin Smith Profile: Colin Smith

I had a customer call and complain that a select distinct statement was taking over 10 minutes to run and they thought that was to long. The table they are running the query against does have over 600 million rows so it is not a small table but it is partitioned. So I started looking into it and I...


November 25, 2011  3:33 PM

Powershell Truncate a String

Colin Smith Colin Smith Profile: Colin Smith

I am working on a script where I need to push some data into an oracle database. That is easy enough as I know that I can use sqlplus to execute my query into oracle but, the Oracle column that I am putting data into cannot be ny more than 10 characters. Some of the data that I want to put in is...


November 24, 2011  8:00 AM

Happy Thanksgiving

Colin Smith Colin Smith Profile: Colin Smith

Today is Thanksgiving so I wanted to wish you all a happy and safe Thanksgiving. I am sure that you have plenty to be thankful for as do I. Here are just a few things that I am very thankful for. 1. My Wife - We have been married for over 14 years now and not many people thought we would last...


November 23, 2011  6:00 PM

Google Calender synch with Outlook

Colin Smith Colin Smith Profile: Colin Smith

So I said that I would like to get my Outlook calendar to synch with my Google calendar so I can get my calendar events on my phone. Well it was easy. Just go get Google Calendar Synch. This will do just that and it...


November 23, 2011  8:00 AM

Blackberry Forward SMS and Phone calls

Colin Smith Colin Smith Profile: Colin Smith

My new job will not let me connect my Andriod device to the Exchange servers so I can not get my calendar and email. Well I thought that is OK as long as I am on-call I will carry my company issued Blackberry and when I am not I will not, but I still want to make myself available if something comes...


November 22, 2011  6:30 PM

Interviewing Tips

Colin Smith Colin Smith Profile: Colin Smith

I do not claim to be a great interviewer at all but I think I do OK, I have a job and I got it only a couple months ago. Since I have been at the new position I have participated in interviews for a DBA position that we currently have open and I have been very surprised. We are looking primarily...


November 22, 2011  4:05 PM

SQL Server 2012 Licensing

Colin Smith Colin Smith Profile: Colin Smith

Make sure you check this out. Some changes are coming with SQL Server 2012 that you will need to be aware of. http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx


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: