Quickly identify thin & duplicate content for Google Panda

How to block SEMalt in nginx and get your own back (a bit)

SEMalt is well known as a major referral spammer who clog up the analytics of a lot of small and medium sized websites with fake traffic. Annoyingly Google Analytics seems to be pretty bad at filtering it out.

Export VBA code from Excel files using Perl

One of the most important features that Excel is missing is some sort of version control. This means writing macros and VBA can be a hugely hit & miss affair.

SECrawl beta: audit for search, with search

Does anyone need yet another website crawler?

Export Webmaster Tools Crawl Stats

Google’s Webmaster Tools offers some fairly handy crawl stats charts, which can be useful in diagnosing crawl issues that Google has with your site.

How accurate the stats are is up for debate (as with all WMT data), but sometimes an…

Remembering Jaamit

Very sad that I couldn’t make it to Ealing today to say goodbye to my friend & colleague Jaamit Durrani, due to this damn freak weather. So instead I wanted to write a little bit about Jaamit as I knew him. I have held off writing anything much until now, but today should be a day for…

Dynamically fetch web page contents in Excel

Excel’s built-in web features are pretty frustrating when you want to do more with the web than import a static HTML table to a predefined set of cells.