Windows 10 connect to Mac on local network

In 2016 it should be easy to move files between two computers on the same network. However it took me a little bit of time to find out how to do this with Windows 10. I was hoping it would be a case of enabling sharing on the Mac, finding it in the Network list… Read More »

Magento SQL query for customer with billing and shipping address

Here is an SQL query I construct to extract customers with billing and shipping address from a Magento 1.9 store. This joins on table sales_flat_order_address to ensure that only customers that have ordered are included. You may need to adjust the entity attribute id’s – if you look in those tables it is pretty obvious… Read More »

Email hosting with multiple accounts for a family

I have looked around for cost effective hosting for multiple mailboxes for example if you have your own domain name and want to give multiple family members email or if you run a small business with a few employees. After a lot of research I recommend Vidahost (that’s an affiliate link but I’m not motivated by… Read More »

Vagrant notes

Stop box checking for updates If you want to stop your VM from checking for updates to the Vagrant box add the following immediately after the Vagrant.configure line: # don’t check for VM updates config.vm.box_check_update = false Update Guest Additions There is a plugin: vagrant-vbguest which will check if your VirtualBox Guest Additions are out of date in… Read More »

Easy Linux MySQL default configuration on cloud server

When you initially install MySQL on a cloud server (Ubuntu 14.04) the /etc/mysql/my.cnf file is configured to work with only 32M RAM. This is pretty crazy when you consider that most cloud servers have at least 1GB of RAM, it could be holding your website up so it is something you should consider changing. If… Read More »