The Multifunctioning DBA:

August, 2009


August 31, 2009  4:15 PM

Support Fallen Troop Families

Colin Smith Colin Smith Profile: Colin Smith

This holiday weekend is Patriot Golf Day. You can check it out here: http://sarasota.golfersguide.com/golf/sarasota-news/patriot-golf-day-september-4-7-2009.html Please check this out and go play some golf over the long weekend. Find a participating course near you and go play for a good cause.

August 28, 2009  7:12 PM

Powershell execute SQL Server Jobs

Colin Smith Colin Smith Profile: Colin Smith

I have been asked to write a script that will allow users to connect to a server, get a list of only the jobs that I want them to see, and execute only those jobs. No options to do anything other than execute the job. This is what I have come up...


August 27, 2009  3:44 PM

More of the TV Saga

Colin Smith Colin Smith Profile: Colin Smith

Today is really the point of no return for me in this venture of leaving the dish behind. I recieved my shipping boxes for the LNB and two recievers that I had from the dish provider and I am taking them to the UPS Store today. Now I can not just call and say turn it all back on. So far I have been...


August 27, 2009  3:30 PM

Moving System Databases in MSSQL2005

Colin Smith Colin Smith Profile: Colin Smith

Recently I had to move all system databases for one server to another physical drive. This is pretty simple for all but the Master and SystemRecource databases. For all others you can just do the following and then copy the mdf and ldf files to the new location.


August 27, 2009  3:13 PM

Questions about health check script

Colin Smith Colin Smith Profile: Colin Smith

I recieved a comment that contained a question about my previous post about writing a script to output a health check of SQL Server. http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/ The following is the question: should we make anychanges for this do...


August 21, 2009  9:26 PM

Dynamic DNS

Colin Smith Colin Smith Profile: Colin Smith

Dyndns.com is a site that I talked about in my last post. It is a free service, or premium depending on what you need, that allows someone with a dynamic ip to access there computer or site with a name like yourname.dyndns.org. It is a great way to be able to get to whatever it is you are doing....


August 21, 2009  9:22 PM

More on the Free TV Move

Colin Smith Colin Smith Profile: Colin Smith

Things are still going pretty good and I even found a nice little add on that should allow me to manage all my recordings, let me watch my video, and listen to my music from the web. It is called webguide. This is something that ties into Vista Media Center and allows you to do all this. (so they...


August 20, 2009  4:05 PM

TV Conversion Update

Colin Smith Colin Smith Profile: Colin Smith

So I have been working on this for a few days and everything is going pretty well. I have two WINTV-HVR 950Q External USB 2.0 HD Tuners connected to my PC. These things are great. Highty recommend them if you are looking for a good easy Tuner for under $100 dollars. I got mine on sale for $70.00....


August 18, 2009  6:00 PM

Powershell Profile

Colin Smith Colin Smith Profile: Colin Smith

The Powershell Profile is a script that druns anytime you launch Powershell. This is handy so you can ste up variables, add snapins, or just do what ever you like or think is cool when launching Powershell. I was just editing mine, which you can do by: notepad $profile This will pull up your...


August 18, 2009  5:47 PM

Find how many files of any extension are in a folder

Colin Smith Colin Smith Profile: Colin Smith

Recently I needed to find out if I had any files of a certain extension in a particular folder and if so how many. With Powershell this is no problem at all. Say I was looking for a count of .ps1 files in the directory.


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: