31 articles Articles posted in Uncategorized

Control all of your devices (cheaply!) using your Amazon Echo/Alexa (TV, appliances, Netflix, Lamps) with the Broadlink RM Pro

If like me you have Amazon Echo(s) you’re probably lured by home automation but don’t want to spend the serious £££ on the various expensive solutions. I had a few requirements that I wanted to set-up for as cheaply as possible to work with the Amazon Echo / Alexa: Turn various lamps on/off Turn the TV on/off Control the TV volume/mute Turn my set-top box on/off (I have a BT YouView box from the UK, …

Continue reading →

Selectively route traffic through VPN on OSX (PPTP, L2TP/IPSEC)

Whilst working from home I found a need to constantly have VPN access to corporate resources (intranet and other internal systems) but without routing all traffic through the VPN. Adding the relevant search domains and unchecking “Send all traffic over VPN connection.” is not good enough unfortunately, i’m currently in an all or nothing scenario, so we need to manually route the traffic: Create the file /etc/ppp/ip-up with following content: #!/bin/sh /sbin/route add SUBNET $5 Replacing SUBNET with the …

Continue reading →

Resizing a VirtualBox VHD or VDI file on Mac OS X

Resizing a VirtualBox VHD or VDI file on Mac OS X

I recently created a Windows 8 VM using VirtualBox on my iMac and misjudged how much space I would need, however not being an experienced VirtualBox user I didn’t realise you wouldn’t be able to increase the VM size from within the GUI. After a quick google session I also found that the advice on resizing VirtualBox VMs was very Windows-centric, so I thought i’d post step-by-step instructions for all you Mac VirtualBox users our …

Continue reading →

Excel 2010 & 2013: Insert / Data menus greyed out, can’t click on PivotCharts / PivotTables

Excel 2010 & 2013: Insert / Data menus greyed out, can’t click on PivotCharts / PivotTables

Help! That’s exactly what I felt like in this situation. I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldn’t interact with the Insert or Data menus (they were entirely greyed out), I also couldn’t interact with my PivotCharts at all. I spent half an hour scouring the Internet and reading that it may be to do with my Sharing or Protected Workbook options, but my workbook was neither …

Continue reading →

Acmeten Website Design, Cambridge.

Acmeten Website Design, Cambridge.

Rob Macintosh is a freelance website and graphic designer based in Cambridge, UK. He’s recently launched his freelance portfolio: “I’ve been freelancing for several years now, and have 6 years website design experience. I work on a wide variety of projects, including working with small new businesses looking to establish themselves and their brand on the Internet, as well as customers large and small looking to refresh their look or who require more functionality. Please …

Continue reading →

Enabling telnet on Windows 7

Enabling telnet on Windows 7

If you’re an avid Windows Vista or Windows 7 user, you might notice that the “telnet” command no longer works – this is because it’s disabled by default in Vista and above, for security reasons. You can however simply re-enable it from the control panel: Control Panel > Programs and Features > Turn Windows features on or off > Tick “Telnet Client” and hit OK.

Continue reading →

How does Formula 1 driver numbering work?

How does Formula 1 driver numbering work?

This is something most people may not think about, but it’s interesting if you’re an f1 geek. Each driver is assigned a number – the previous season’s champion is assigned number 1, whilst his team-mate number 2. Number’s are then assigned in order according to each team’s position in the previous season’s constructors’ championship. Curiously, the number 13 is not used. Superstitious, FIA?

Continue reading →

F1 Championship 2010, how is it stacking up with 6 races to go?

F1 Championship 2010, how is it stacking up with 6 races to go?

I posted almost exactly 3 months ago with my opinion of the new season, it’s teams and drivers, new rules, and a prediction for the end of the season. Has any of it changed? Here’s the original post, have a quick read. My prediction then was: 1. Lewis Hamilton 2. Sebastian Vettel 3. Mark Webber 4. Jenson Button 5. Fernando Alonso 6. Felipe Massa 7. Robert Kubica 8. Nico Rosberg The standings as they are …

Continue reading →

Westboro Baptist Church (God Hates Fags) vs Brick Stone

Westboro Baptist Church are well known for their anti-homosexual propaganda/pickets, and at a recent picket they received an un-expected visit from comedic journalist Brick Stone. Watch the video, you’ll not regret it. If you’re not familiar with Westboro Baptist Church, read more about them on wiki, or take a look at their hilarious website: Wikipedia Official Site

Continue reading →

Basic MySQL commands

Basic MySQL commands

Some people use MySQL day in day out, some use it sporadically – if you ever play with web systems (blogs, knowledgebase software) or generally anything that needs a good database/backend, you’ll at some point need to know the basic/common commands and syntax. Below when you see # it means from the unix shell. When you see mysql> it means from a MySQL prompt after logging into MySQL. To login (from unix shell) use -h …

Continue reading →