How to remove 'Permanently shred with AVG' from your context menu

By Mike Lewis

If you have recently installed – or upgraded to – AVG 2014, you might have noticed a new item on context menus in Windows Explorer. The item reads 'Permanently shred with AVG', and it does what its name suggests: It completely destroys the file or folder you are pointing to, without any chance of recovery.

Now, it could be that you will find this feature useful. If you want to place some confidential information beyond the reach of the Recycle Bin or a file recovery tool, this is a good way of doing it. But if, like me, you are worried about accidentally shredding an important file, you might prefer to remove this menu option. Here's how to go about it.

How to stop the Samsung Galaxy from vibrating

By Mike Lewis

One of the things I dislike about my new Samsung Galaxy tablet is the way it vibrates at every opportunity – whether I want it to or not. It does this when I switch the device on, press the Home button, press and hold the Power button, and at several other times too.

This is irritating, not least because it’s unnecessary. I could understand it if the vibrations alerted me to an important event, such as an incoming message. But there is no reason to have this kind of haptic feedback every time I press certain buttons. (It’s also adds to the drain on the battery.)

Google's disavow tool revisited

By Lynn Evans

About a year ago, I submitted some suspicious links to Google’s disavow tool – against the strident advice of several friends and colleagues. Almost everyone I spoke to warned me against doing this. But I went ahead anyway – with a surprising result.

The usual argument against using the disavow tool is that it draws attention to dodgy links that you might have planted yourself – and therefore risks a penalty. I never understood that. If Google thinks the links are spammy, it will ignore them or penalize you in any case. The disavow tool is your chance to tell the search engine that you are not responsible for the links. Another reason not to use it is that you might inadvertently remove reputable links that are helping your rankings. That sounds more plausible to me.

In my case, the site had attracted several thousand links over the years. But about 900 of these were coming from what was clearly a link farm. I don’t know how or why they got there – it was certainly none of my doing. It was these links that I wanted to disavow.

Speeding up postcode queries

By John Hyde

In an article on Hex Central, Mike Lewis showed how to calculate the distance between any two British postcodes. Here’s a tip for speeding up the process.

The calculation that Mike demonstrated is a simple application of Pythagoras’ theorem. You start by getting the grid references (that is, the x, y co-ordinates) of the two postcodes. Next, add the sums of the squares of the x and y distances between them. Finally, take the square root of the value thus obtained. That final figure is the straight line distance between the two points.

My tip is simply to omit the calculation of the square root. So, instead of working with the actual distance, you work with the square of that distance.

As an example, let’s suppose you want to sort a series of postcode pairs into descending order of distance apart. You omit the calculation of the square root, which means that you will in fact be sorting by the square of the distance apart. The result will still be correct.

Similarly, if you want to find all postcodes within a given radius of a fixed point, you omit the square root calculation, and compare the distances with the square of the target radius. Again, this will give the correct result.

Since the calculation of the square root is likely to be the most time-consuming part of the process, leaving it out should speed things up considerably.

New tracks not appearing in the iTunes music library

By Mike Lewis

For several years, I've been happily using iTunes to organize my music collection and transfer tracks to my iPod. Then, quite suddenly, it stopped working. More specifically, I found I could no longer add new tracks to my music library. There was no error message, no unusual behavior. The newly-added tracks were simply nowhere in sight.

I eventually found a solution, but only after much searching and experimenting. I'll summarize the steps here, for the benefit of any Hex Central readers who face the same issue.

FileSystemObject performance issues

By Mike Lewis

In a recent Hex Central article, I explained how you can use the FileSystemObject to read and write large text files in Visual FoxPro. One of the main reasons for doing that is to work with files that would otherwise break VFP's 2 GB limit.

Unfortunately, that benefit comes at a price. In many cases, the FileSystemObject will be a lot slower than using native VFP commands and functions.

Welcome improvements to AdSense reports

By Donald Ritchie

Google have just made some small - but very welcome - improvements to their AdSense reports. They've made it easier for you to spot medium- and long-term trends in your AdSense data. They've introduced a number of useful new graph types. And they now let you see at a glance the effect of any changes you make to your AdSense setup, such as introducing a new ad unit, or blocking a sensitive category.