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 →

Windows 7 drag and drop isn’t working, quick-fix.

I have found that infrequently dragging and dropping stops working within an explorer shell. Having googled there seems to be numerous causes. For a quick fix which works for me, try:  Press Ctrl-Alt-Del  Press Esc This works for me every time, and it happens infrequently enough that i’m happy to put up with the workaround rather than trying to find the root cause!

Continue reading →

How to remove a git alias

I’m just getting started with git and ended up creating a number of duff aliases, to remove aliases use the following command in your git shell: git config –global –unset alias.myAlias

Continue reading →

Can’t connect to a local server using the Hyper-V Manager

Can’t connect to a local server using the Hyper-V Manager

I was trying to connect to a local (i.e. on the same domain) Hyper-V server for the first time from my laptop, using the Hyper-V Manager (which is included in the RSAT tools), and received the following error regarding permissions:   The solution in this instance was actually very simple, given that i’d installed the Hyper-V server using relatively default settings before joining it to the domain, by default only local and domain administrators have …

Continue reading →

Clearing/Deleting MSSQL Server wait statistics (performance troubleshooting)

Clearing/Deleting MSSQL Server wait statistics (performance troubleshooting)

Troubleshooting SQL Server performance issues is a huge subject, but I often start by analysing the wait (sys.dm_os_wait_stats) and virtual file statistics (sys.dm_io_virtual_file_stats) in parallel. If the performance issues are not blocking, then it is always a good idea to clear the wait statistics and then let server run for a set period (Hour, Day, Week) giving you a good set of data to work with. Wait stats are cleared by running: DBCC SQLPERF(‘sys.dm_os_wait_stats’, CLEAR) However …

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: Insert / Data menus greyed out, can’t click on PivotCharts / PivotTables

Excel 2010: 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 →

Orijin Design – Website & Graphic Design

Orijin Design – Website & Graphic Design

UPDATE: Orijin Design is now Acmeten, see the website here: http://www.acmeten.co.uk Orijin Design is based in Cambridge and they’ve been designing and developing websites for nearly 6 years. They work with a multitude of local Cambridge individuals, businesses, charities and not-for-profit organisations. Their websites are beautifully designed and search engine friendly, they offer a broad range of flexibility, which makes for a healthy working relationship for clients. “We love working locally on all manner of projects, for …

Continue reading →