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.

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

CREATE TABLE newtable
SELECT DISTINCT *
FROM oldtable


Then empty the old table

TRUNCATE TABLE oldtable


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

INSERT INTO oldtable
SELECT * FROM newtable


Simplez

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

http://image.guardian.co.uk/sys-files/Guardian/documents/2011/07/07/Newworldmap2.pdf

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)

http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

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

http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm

Is your voicemail secure?

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

http://www.guardian.co.uk/money/blog/2011/jul/08/how-to-avoid-getting-your-phone-hacked

Google Plus tutorials

Round up of tutorials for Google Plus

http://www.famousbloggers.net/google-plus-tutorials.html

Whats the average salary?

Its based on US jobs but still a very useful tool for comparing salaries and skills.
http://www.indeed.com/salary

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

http://www.indeed.com/salary?q1=java&l1=&q2=php&l2=&tm=1

java $95,000
php $81,000

View Larger Salary Graph

And of course in Google you can simply type 80000 dollars in pounds
http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=81000+dollars+in+pounds


There's also a trend tool to see if your job or skills are in demand
http://www.indeed.com/jobtrends?q=java%2C+php&l=

java, php Job Trends

Java jobs - PHP jobs

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