SQL Mail issue update Resolved

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...
Powershell Start and Stop -job

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...
Long Weekend

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...
SQL Server Clustering time on Node

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...
Training plan

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...
Training

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...
SQL Mail issue Update

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...
SQLSkills Twitter Quizes

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....
Legacy SQL Mail on SQL Server 2005 SP4

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...
PASS Sumit changing venue

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...