Articles
Best travel mug update and review
The world is a funny place, no soon as you've found your perfect product, the manufacturer has found a way to make it cheaper and probably worse and eventually the shop stops selling it.
This is the sad story of my constant quest to keep myself furnished in Travel mugs. If you've not read my previous editorial on the key constituents of a more »
"You only know what you know how to google"
"You only know what you know how to google" - Martin Childs, 2016 This post was supposed to be about how create a custom Excel VBA function, the origination of the idea was despite my lifelong career of tinkering with excel I'd never come across or had the requirement to have a function cycle through the cell you input as a range to perform a more »
Solve slow network printing from Word
Faster printing over the network from word 34mb print spool to 4mb if pdf from a 26page document graph image word doc. Transmission speeds weren't any faster but took loads less time beacause of the reduced file more »
Top sweets of all time
It's not often I'm partial to having sweets and it is safe to say that I am more of a savory person. So much so Cherry lips Foam bananas Haribo fangtastics Fizzy Cherry cola bottles Haribo tangy monsters - Apple flavour Giant more »
Water fountain location at Heathrow Airport Terminal 3
Unlike at any of the Manchester Airport terminals where they are firmly intent on extracting the most money out of you as possible, Heathrow actually fare a little better - they advertise the locations on their airport plans. Actually I'm coming to realise the whole Manchester experience is pretty rubbish - crap food outlets, broken water more »
How to pivot data by month in SQL and output to a temporary table
There are some things that aren't easy to do in SQL as you'd like. I don't know why it has to make the seemingly simple things to complete in Excel so annoyingly tricky.
Dynamic pivots is one of those things that is overcomplicated, sure there's plenty of tutorials on the t'internet , but what they all seem to lack is instructions of how to write more »
The great Indian restaurant lamb scandal?
Whilst we were out in Tanzania on Safari something wasn't quite adding up, every night at the hotels there was several Lamb dishes to be found on the menu. The thing was vexing me was that despite being in the country for nearly a week and spending at least eight hours a day driving through various types of countryside I'd yet to lay eyes on more »
How to convert a text DDMMMYYY date in SQL
As much as I love Excel there are some circumstances where it just doesn't cut it - more than a millions rows and computer says no; some rediculouse vlookup and you could be there for hours. So step in SQL, it can do those aforementioned tasks in a matter of seconds.
There are a couple of occasions though where SQL is not king, one of these is more »
How to set up your Dell E310dw printer the really easy, bloat free way on windows
One of the common themes of the computer industry is to try to install a load of bloat on your computer under the guise of making it easier for you, well when I first got my Dell E310dw and had a flick through the setup guide to head off any such shinangans I noticed they had some sort of 'universal' installer.
Trying not to fall for that I more »
- Getting ExifTool's move files to directories to work properly as Windows batch file
- How to easily & perfectly align your Stem
- How to remove bicycle tyre marks from painted walls
- What's your Robot name?
- Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
- How to clean the lid and nozzle of your Camelbak Podium bottle
- How to enable and change the Remote IR GPIO pin in OSMC
- Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
- My new scale for measuring oldness
- A datedif function for excel that calculates correctly
- Raspberry Pi 3 HDMI overscan settings and how to correct them
- Create custom Excel function using an array/range input
- SSL on a RaspberryPi - does it slow your site down?
- Remove Real VNC from RaspberryPi Pixel and install TightVNC
- Running a SSL certificated/authenticated HTTPS website over dynamic DNS