The Multifunctioning DBA: June, 2011 archives

June 30, 2011 8:00 AM

My New Favorite Web Site

Posted by: Colin Smith

Help

This has probably been around for a long time and I just did not know but I do now. Ever have someone come up to you and ask a question and you think to yourself,, "Self, They did not even try to figure this out." Well that happens to me all the time and now I have a good way to respond to them....

0 Comments

RSS Feed

Email a friend

June 29, 2011 7:00 PM

Not Paying For Cable or Satalite

Posted by: Colin Smith

Entertainment, Internet TV

In the recent weeks I have had many people come up to me and ask about how I get TV content without a Cable or Satellite provider. The answer is pretty simple really. I use Over The Air (OTA) for all local content and the internet for the rest. I am sure that there are many ways to do this but I...

0 Comments

RSS Feed

Email a friend

June 29, 2011 6:00 PM

MS Cert Test prices go up on the 1st

Posted by: Colin Smith

Certification, Training

Just a quick reminder that if you want to get an MS Certification you need to get it on the books by the first or you will be paying an additional $25.00 staring on July 1st. So get out there and get it done. Thanks

0 Comments

RSS Feed

Email a friend

June 29, 2011 4:19 PM

Good Baby News

Posted by: Colin Smith

Baby, Personal

Last week my wife went in to have some tests done to find out the odds of the baby having some genetic defects. This was really cool as we got to do a 3d ultrasound and really got to see some cool pictures of the baby. It was really amazing. It is almost like looking at a photo of the baby. Now my...

0 Comments

RSS Feed

Email a friend

June 23, 2011 4:33 PM

AZ POSH

Posted by: Colin Smith

AZ POSH, POSH, Powershell, Training

The Arizona Powershell users group has started posting meeting videos online. this is very cool because I usually do not have the ability to get to the meetings but I would love to see the content. So far the content has been great and I really hope that they can continue to post these for us....

0 Comments

RSS Feed

Email a friend

June 23, 2011 8:00 AM

PASS Summit Disappointment

Posted by: Colin Smith

PASS Summit, Speaking, Training

Last week I was notified that my submission to speak at the PASS SUMMIT was not accepted. I am bummed out about it very much. This means that I will not be attending the SUMMIT this year and I really wanted to go. I just can not get work to pay for the SUMMIT and all the travel since I am also...

0 Comments

RSS Feed

Email a friend

June 22, 2011 11:00 PM

Check DB online before running Job

Posted by: Colin Smith

DB Online, T-SQL

I was also asked to make sure that I have jobs set up on my servers that have database mirroring set up. They only want the job to run if the database is online and they do not want to have to enable and disable jobs when failovers occur. So I did the following.

June 22, 2011 8:23 PM

Fail over Mirror database with Powershell

Posted by: Colin Smith

DR, Mirror, Mirror Fail over, Powershell

Today I was asked if I could help out by writing a simple script that would fail over a mirrored database from one server to the other and back if and when needed. I thought sure I can. I mean to do the failover with T-SQL is really simple but I can automate it. So here is the T-SQL to fail...

0 Comments

RSS Feed

Email a friend

June 21, 2011 7:00 PM

Blue Ray Issues

Posted by: Colin Smith

BD, DLNA, Network Devices, WHS

this weekend I went out and I purchased a blue ray player that would go into a room that does not get used much but since I do not have Cable or Satellite, I wanted to be able to watch all my media from my media center and from the web and from my DLNA server in that room. I went and found what...

0 Comments

RSS Feed

Email a friend

12 NEXT