The Multifunctioning DBA:

June, 2011


June 30, 2011  6:46 PM

Great “Golden Rule” Post

Colin Smith Colin Smith Profile: Colin Smith

Check out this post by Paul Randal(Blog | Twitter)

June 30, 2011  8:00 AM

My New Favorite Web Site

Colin Smith Colin Smith Profile: Colin Smith

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


June 29, 2011  7:00 PM

Not Paying For Cable or Satalite

Colin Smith Colin Smith Profile: Colin Smith

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


June 29, 2011  6:00 PM

MS Cert Test prices go up on the 1st

Colin Smith Colin Smith Profile: Colin Smith

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


June 29, 2011  4:19 PM

Good Baby News

Colin Smith Colin Smith Profile: Colin Smith

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


June 23, 2011  4:33 PM

AZ POSH

Colin Smith Colin Smith Profile: Colin Smith

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


June 23, 2011  8:00 AM

PASS Summit Disappointment

Colin Smith Colin Smith Profile: Colin Smith

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


June 22, 2011  11:00 PM

Check DB online before running Job

Colin Smith Colin Smith Profile: Colin Smith

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

Colin Smith Colin Smith Profile: Colin Smith

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


June 21, 2011  7:00 PM

Blue Ray Issues

Colin Smith Colin Smith Profile: Colin Smith

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


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: