SQL Mail issue update Resolved
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...
0 Comments
RSS Feed
Email a friend
Powershell Start and Stop -job
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...
0 Comments
RSS Feed
Email a friend
Long Weekend
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...
0 Comments
RSS Feed
Email a friend
SQL Server Clustering time on Node
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...
0 Comments
RSS Feed
Email a friend
Training plan
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...
0 Comments
RSS Feed
Email a friend
Training
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...
0 Comments
RSS Feed
Email a friend
SQL Mail issue Update
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...
0 Comments
RSS Feed
Email a friend
SQLSkills Twitter Quizes
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....
0 Comments
RSS Feed
Email a friend
Legacy SQL Mail on SQL Server 2005 SP4
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...
0 Comments
RSS Feed
Email a friend
PASS Sumit changing venue
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...
0 Comments
RSS Feed
Email a friend
