Moving From One Computer To Another With Existing Checkouts In TFS (Team Foundation Server)

Posted by Paul Farrow - Under: Microsoft Windows, Software

My laptop was corrupted and decided to move to another laptop at work. I had existing checkouts so I copied all the code involved to the new laptop. Then I couldn’t add the workspace with the same name as it kept saying the workspace exists on my old machine.

I looked around at posts on the internet and they were suggesting to use the tfs commands

I tried to use

tf workspaces [/updateComputerName:oldComputerName][workspacename]

Now I don’t know what was wrong but it didn’t work at all. So I took the brute force approach and updated the TFS database itself using the SQL management studio.

I used

UPDATE [TFSDBName].[dbo].[tbl_Workspace]

SET Computer = ‘NewMachineName’ WHERE Computer = ‘OldMachineName’

and that worked a treat.   If your worried then do a select first and make sure you know how many it should be updating first and do a begin transaction before the statement – just to make sure your updating the right amount.  Or even do a select afterwards to see the data changed and then issue a commit command.

Global Emergency Resources LLC – 57th Presidential Inauguration.

Posted by Paul Farrow - Under: Personal, Software

Over the last couple of weeks I was very privileged to have some of the software that I have worked on being used for the 57th Presidential Inauguration. It is probably my biggest career moment ever – so far !

My employer Global Emergency Resources LLC landed a contract to supply the first aid locations and command centers with their product – HC Standard.

Ex·cerpt from Global Emergency Resource’s website:

WASHINGTON, D.C. – The 2013 Presidential Inauguration brought landmark changes in emergency management and spectator safety. For the first time, inaugural personnel used a powerful situational awareness software suite to track medical emergencies; reunite lost family members; and provide real time information to event organizers. Emergency personnel from The District of Columbia, Maryland, Virginia, and the United States military integrated emergency data using HC Standard® – a patient tracking and critical asset software solution developed by Global Emergency Resources, LLC based in Augusta, Georgia.

HC Standard® allowed local, state and federal agencies, including the National Parks Service, US Secret Service, the Red Cross, and Homeland Security officials to have a common operating picture of major events during the Inauguration, including the Presidential Candlelight Reception; the Inaugural Parade; activities along the National Mall; the Commander in Chief Ball; the Inaugural Ball; and the Inaugural Prayer Service.

The DC Department of Health partnered with the Maryland Institute for Emergency Medical Service Systems (MIEMSS), the Northern Virginia Emergency Response System (NVERS), and the Maryland Department of Human Resources (MD DHS) to provide patient care and tracking throughout the event. Each partner used its own installation of HC Standard® to enter patient data with Motorola MC65 handheld devices. The data was aggregated and shared in all systems so that EMTs, first responders, and command center leaders could see the full picture of Inaugural events as they occurred.

During the Inauguration, HC Standard® tracked every emergency or first aid case and plotted it in each of the three emergency operations centers used for the event tracking and management. Additionally, family members who were lost, and those who were looking for them, had their information uploaded to a multijurisdictional database so they could be more easily reunited. Even the 100+ horses that carried the mounted police were part of the HC Standard® operating picture.

“Interoperability was key,” says Stan Kuzia, CEO and founder of Global Emergency Resources. “The EMS and Healthcare partners in the National Capital Region (NCR) have worked diligently over the years to eliminate information silos and enhance communication. This Presidential Inauguration demonstrated their hard work is paying off”. The various civilian agencies in the NCR also worked closely with their military counterparts to share a combined picture of patients and missing persons being treated and handled during the entire event. HC Standard® helped to bridge the interoperability gaps on Inauguration Day as near real-time data was available to military responders just as fast as their civilian counterparts.

Original document can be found here: http://www.ger911.com/news-and-events/17-news/133-inauguration2013

The French Market Grille, Surrey Center, Augusta, GA.

Posted by Paul Farrow - Under: Personal

So my outlaws invited me and the wife to go down to The French Market Grille last week. My initial impression was good, it was busy, fairly noisy which I like in a restaurant.

Service was a bit slow initially with it taking a long time for the drinks to come out.

The food was excellent. I ordered the seafood gumbo (delicious), followed by the crab chop (again excellent) and finished off with some sort of cream pie (out of this world).

One thing that was odd was the waitress asked if we wanted the dessert menus when we basically had just started eating our main course !!

CONCLUSION: The food was excellent and I would definitely go back.

There is a twist though, the next day checked the bank account and for some reason they had put another check through for 72 bucks on my card. The extra amount was nothing to do with us. Rang them up and they weren’t really that apologetic but did take it off.

MySQL pegging CPU after the leap second adjustment.

Posted by Paul Farrow - Under: Linux, Software

So I find that my MySQL database is running high on CPU all of a sudden. I optimize the tables etc and no difference. I hunt around the internet to find that there seems to be a problem with this years leap second adjustment which sends MySQL into orbit.

The solution reset the date

date -s "`date`"

and it dropped back to normal.

Credit goes to this lady here http://www.sheeri.com/content/mysql-and-leap-second-high-cpu-and-fix

Hash (#) Key On The Apple Macbook Pro.

Posted by Paul Farrow - Under: Personal

Now I keep forgetting the key combination for getting the hash key on my MacBook Pro. Now this is as much for me as everyone else.

Wait for it, its ….

Alt + 3

Chris May Rides From London To Brighton In Aid Of The Meadow House Hospice

Posted by Paul Farrow - Under: Personal

Its all self explanatory, lets help Chris get to a 1000 pounds. Get funding here

YouTube Preview Image

Chris made it. Click here to see the stats from his monitoring software. And stage two of his trip here.

36th Annual Palmetto Amateur Golf Tournament TV Commercial.

Posted by Paul Farrow - Under: Personal

One of my experiences here in the USA has been to be a voice over for a set of TV commercials. My friend from church Tom Kotti asked me if I was willing to use my English accent and be the voice over for a TV commercial he was making. I was game, so I said “yes sure”. The TV commercials were for the 36th annual Palmetto golf tournament at the Palmetto Golf Club which has been established in Aiken since 1892. Here is one of the commercials.

YouTube Preview Image

I enjoyed the experience immensely and if any one wants to use my voice again please contact me via this blog.

BackupPC Has qw(…) Warnings Since Upgrading Perl

Posted by Paul Farrow - Under: Linux, Software

So since upgrading Perl I am presented with qw warnings coming out of the cron job checking that BackupPC is running.

Use of qw(...) as parentheses is deprecated at /usr/share/BackupPC/lib/BackupPC/Storage/Text.pm line 301.
Use of qw(...) as parentheses is deprecated at /usr/share/BackupPC/lib/BackupPC/Lib.pm line 1412.

The way to get rid of these warnings is to enclose qw in parentheses and Perl processes the foreach parameters without warnings.

Like so

Text.pm (Line 301)

#
# Promote BackupFilesOnly and BackupFilesExclude to hashes
#
foreach my $param (qw(BackupFilesOnly BackupFilesExclude)) {
next if ( !defined($conf->{$param}) || ref($conf->{$param}) eq "HASH" );
$conf->{$param} = [ $conf->{$param} ]
if ( ref($conf->{$param}) ne "ARRAY" );
$conf->{$param} = { "*" => $conf->{$param} };
}


Lib.pm (Line 1412)

foreach my $param (qw(BackupFilesOnly BackupFilesExclude)) {
next if ( !defined($conf->{$param}) );
if ( ref($conf->{$param}) eq "HASH" ) {

Vallarta Mexican Restaurant, Washington Road, Augusta, GA

Posted by Paul Farrow - Under: Personal

One of my work colleagues put me onto this place, Vallarta Mexican Restaurant, Washington Road, Augusta, GA. It serves what I thought was excellent Mexican food and I liked the place very much. So much my wife and I made it a regular visit every week, as we loved the Patron chicken salad which is on special for lunch on Tuesdays.  We have been going there every week for about a year when this week (Tuesday 24th January, 2012) we ordered two Patron salads and the meals arrived. I tucked into mine and commented that it tasted slightly different. My wife told me that it was me, it was fine as always. Then about ten minutes into the meal my wife spat out some chicken stating it was rotten. On closer inspection it smelt like the worst trash can you had smelt. The chicken was clearly rotten. I was nearly sick when I smelt it.

We got the waiters attention and he got the manager. The manager looked at us like we were mental and didn’t really say anything about it. We paid for our drinks and left. It was one of the most disgusting things that I have experienced in my life, it has really put me off going back there.

CryoDefense

Posted by Paul Farrow - Under: Software, Windows Mobile

Just like to give out a shout to a young man Neil Bostrom who I had the pleasure of working with at Standard Life Healthcare.  It seems in the last year he has not only launched a company TreeHouse Development but a new game for the Microsoft Windows 7 Phone platform and its called CryoDefense.

CryoDefense Logo