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

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.

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

MySQL pegging CPU after the leap second adjustment.

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

36th Annual Palmetto Amateur Golf Tournament TV Commercial.

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.

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

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" ) {

End Of An Era

Back in May of 1994 I opened my company Farrow Computing Limited when I was a mere boy.  I never thought I would be as successful as I was with it.  But finally because of my emigration to the USA, it was closed at the end of March 2010, sixteen years of running my own business.

Looking back there were plenty of times of “what if I cant get work..”  “What if I mess something up”, but looking back it really did go well.  Enjoyed most of it.

Truly the end of an era.

Zotac ION-ITX-F Wi-Fi Dual Core 1.6GHz Atom N330 Mini-ITX Motherboard with PCI Express x16 With Windows 7 Home Premium


Zotac ION-ITX-F

Originally uploaded by paulfarrow

After putting a power meter on my home entertainment system realised that my equipment was using a lot of power 350 watts at peak. So thought I would do some investigation into a recent low power mini-itx board from Zotac. I chose this one because it was dual core and it has a pci-express card on it which is good for a cable tuner I am looking at to use in it for when I am in the USA.

Ordered the board from mini-itx.com as they are the only people I could find doing this board. It came and everything looked fine except that the fan isnt fitted and there are no holes for it on the cpu heat sink. After talking with mini-itx they told me to screw it to the heatsink even though it doesnt have any predetermined holes. I also noticed that the manuals that came with it – the quick installation and the main manual werent for this board. Which was a great start.


Zotac ION-ITX-F

Originally uploaded by paulfarrow

I had already converted my old system from Vista to Windows 7. I then put the new Atom board into my case and started it up. Immediately I was getting checksum errors and just stalled. I was like oh dear must be memory related so twiddled about a bit with the memory until I found the culprit. From going from 1 board to the other, one stick of my 2Gb DDR2 had decided to die.

Not a real problem as really 2Gb of memory should be ok for what that board needs to do. So once over that everything came up fine. I use this as my media center so mainly playing music and watching tv (SD & HD blu-ray).

Initial reaction was that its great. So lets put it through its paces, watching blu-ray with fast moving action – didnt phase it at all everything was running fine at 17% cpu and wattage was about 270 watts so it was already saving me about 70 watts of power. I then decided to get it to record two tv stations and watch a recorded program at the same time.

It did this as well although cpu was about going from about 50 to 75%. And when navigating through the menu it was a bit sluggish although livable. All in all it is great because it will save me money and the Windows 7 media center is a little better than the old Vista one.

FURTHER UPDATE:  having recently bought UP on blu-ray I have noticed something that is important for this board.  Some of the later blu-ray’s are recorded in MPEG4 – I have tested UP and The Taking Of Pelham 123, they are both recorded in MPEG4 unlike I Am Legend which is VC1.

MPEG4 is currently running at around 47% cpu usage which is fine on its own but if (like I was at the time of trying to play UP) you are recording tv at the same time its just a bit too much for the little NVIDIA ION board which then runs at 100% and frames and audio drop on the play back of the blu-ray movie.  Its a shame because its a great board and just what I want when the machine is on all the time but its a trade off between performance and cost of running the equipment.

Overall I am still impressed even though there are these obvious trade offs.

Everyone Is Looking For A White Mini Cooper S

I noticed in my stats that everyone is coming to my blog from search engines looking for white Mini Cooper S’s and I realised that I dont actually have a picture of mine from the front. So here it is on the day I bought it waiting to be driven by myself. Shame I sold it back last year. Any way here it is in all its glory …..

White Mini Cooper S - HV57UOA

Drove it many times to France and once to Madrid. It was great fun, nearly as great as my GSX-R 750. Wonder where it is now??? Registration was HV57UOA – post here if you have seen it.

If your looking for more photos or stories about it try clicking the mini tag in my tag cloud.

Started To Sell My Stuff On Ebay

Ok so I have decided to start listing all my stuff that I have lying about the house that isnt being used.  There is quite an extensive range.  So keep coming back to look at my sidebar to see what im selling.

Going to start with a pair of digital freeview tv tuners which I bought back in 2005 and have never used them. So get bidding if you want them…

[Ebay 260547177386] [Ebay 260547177560]