May 27, 2011 11:59 PM
Posted by: Colin Smith
Background Jobs,
PowershellToday 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
Posted by: Colin Smith
Personal,
WeekendWell 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
Posted by: Colin Smith
#sqlhelp,
Cluster uptimeI 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
Posted by: Colin Smith
Do it yourself,
TrainingSo 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
Posted by: Colin Smith
TrainingToday 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
Posted by: Colin Smith
database mail,
sqlhelp,
sqlmailThanks 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
Posted by: Colin Smith
SQLSkillsThe 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
Posted by: 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
Posted by: Colin Smith
PASS,
PASS Summit,
TrainingA 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...
