Tuesday, 19 July 2011

Use your computer to help with cancer research

Use your computer's idle time to research cancer, muscular dystrophy, aids, clean water and many other projects beneficial to all of us.

Simply register at the World Community Grid, choose the projects you want to help with and download their software for Linux, Mac or Windows.

The program will then run in the background when your computer is idle.

The BOINC computer grid is the largest in the world - basically half a million computers, like you and me, working together to produce 5.6 petaFlops to perform complex calculations that would normally take years - even for the most powerful computer.

Friday, 15 July 2011

Delete duplicate rows using SQL

Here's a quick way to delete duplicate rows - make sure you have backed up, just in case!

First create a temporary table using DISTINCT

FROM oldtable

Then empty the old table


Then copy the temporary table - this will ensure all the original table settings remain intact

INSERT INTO oldtable
SELECT * FROM newtable


Friday, 8 July 2011

New country for your databases..

Tomorrow (9th July) we will have a new country - The Republic of South Sudan

The Guardian has conveniently given us a new PDF map of the world for download

You should update your databases / lookups to reflect the change.

There is no official ISO-3166 code as yet, but it is likely to be SS.

If you haven't already done so, you should also have the most recent new country codes:

XK - Kosovo (2008 temporary)
ME - Montenegro (2006)
TL  - East Timor (2002)

You can download a full list of ISO country codes from here - although it doesn't include South Sudan or Kosovo

Is your voicemail secure?

Check your default voicemail settings, its very easy from someone else to check your voicemail.


Friday, 1 July 2011

Whats the average salary?

Its based on US jobs but still a very useful tool for comparing salaries and skills.

You can even add 2 or more skills/job titles to compare the salaries

And of course in Google you can simply type 80000 dollars in pounds

There's also a trend tool to see if your job or skills are in demand

Busy week for Google!

Its been a very busy week for Google - here is a round up

Google News | Updates on +, +1 | New Google Analytics Features

Don't forget to check out Who do you love