The Multifunctioning DBA:

May, 2011

May 30, 2011  7:00 AM

SQL Mail issue update Resolved

Colin Smith Colin Smith Profile: Colin Smith

The other day I posted about an issue I was having with SQL Mail after doing a P2V of a server and also installing SP4 for SQL Server 2005. The root issue was that Outlook would not work on the server and I do not know why. But thanks to Twitter I found sp_send_dbmail and pushed that to our dev...

May 27, 2011  11:59 PM

Powershell Start and Stop -job

Colin Smith Colin Smith Profile: Colin Smith

Today I finished writing a couple scripts that are going to be gathering perfmon counters and pushing them into a DB for me. This is great but I am going to need to run two separate scripts that do this at the same time. So I found Start-job and End-job. these are great because now I can just write...

May 27, 2011  6:05 PM

Long Weekend

Colin Smith Colin Smith Profile: Colin Smith

Well I hope that everyone enjoys the long weekend this year. Today is Friday so I hope that you are able to take it easy today and all weekend. I have to drive about 7 hours to go to a wedding but it should be fun. I am looking forward to getting out of town for a few days and as far away from a...

May 26, 2011  11:00 PM

SQL Server Clustering time on Node

Colin Smith Colin Smith Profile: Colin Smith

I was asked to find out when the last time my sql server instance had failed over on the cluster. I thought mm I should be able to get this from a dmv or something but I could not find out how. Looked at the cluster dmv's and just did not find what I am looking for. Threw the question out on...

May 26, 2011  9:00 PM

Training plan

Colin Smith Colin Smith Profile: Colin Smith

So like I said before, I am lucky and my boss sees value in sending me to training and I do my best to show off that the training works by improving things when I get back. Training can help save the company money in the long term for sure. One thing that I told my boss is that if it costs 5k to...

May 26, 2011  5:20 PM


Colin Smith Colin Smith Profile: Colin Smith

Today a coworker of mine forwarded a blog post to me and it is very well done and very interesting. If you work in a company that does not have training budget or just says that the cost of training is too high, you might want to send this to your boss. I am lucky and my company is willing to...

May 25, 2011  10:44 PM

SQL Mail issue Update

Colin Smith Colin Smith Profile: Colin Smith

Thanks to Twitter I have had a lot of help with the SQL Mail issue that I am having. Unfortunatly I still have not been able to resolve the issue at this time and I am still waiting on hold for MS to help me out with the main issue that is Outlook will not correctly set up the mail profile for some...

May 25, 2011  8:29 PM

SQLSkills Twitter Quizes

Colin Smith Colin Smith Profile: Colin Smith

The team at SQLSkills does a quiz on twitter every Wednesday and if you are not already participating in them I highly recommend that you do. I have only ever answered one question correctly and that was only because the answer was in a previous question....

May 25, 2011  6:28 PM

Legacy SQL Mail on SQL Server 2005 SP4

Colin Smith Colin Smith Profile: Colin Smith

I have a server that is running SQL Server 2005 SP4 and has a bunch of old legacy DTS jobs. These jobs leverage Legacy SQL Mail to send notifications on job steps. I had to P2V this server in order to install SP4 that was required to fix another bug. After the P2V I was able to install SP4 and that...

May 21, 2011  9:00 PM

PASS Sumit changing venue

Colin Smith Colin Smith Profile: Colin Smith

A few days ago PASS announced that the 2013 Summit will be in Charlotte NC. This is great news, in my opinion. I have only been to one Summit and it was AWESOME and I recommend it to any SQL Server pro out there no matter what level you are at. I had such a great time but I do not think that I will...

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: