Category Archives: Technical

Using AND within a FILTER within an ArrayFormula in a GSheet

So I’m talking Google Sheets here, one of the types of available Google Docs. Sheets is like Excel – in many ways. It’s also different – in many ways. So I recently had a situation where I needed to filter … Continue reading

Rate this:

Posted in Technical | Tagged , , , , | Leave a comment

When the stage manager sends in an understudy

So I recently injured my back in a way which is not too serious (I hope) but it means I can’t really take any chances with it for a while either. Which means not really lifting anything and not camping … Continue reading

Rate this:

Posted in Technical | Tagged , , | 2 Comments

Time for just one more …

I was fortunate enough recently to be working at “An Evening With” type event, where a guest was interviewed in front of a mostly, alive, theatre audience. I was the venue’s sound and AV engineer for the event, not a … Continue reading

Rate this:

Posted in Technical | Tagged , , , , , , | Leave a comment

Backing up my MySQL data

This may not be of use or interest to anyone else, but at least I’ll remember where I stored this command for my own future use. mysqldump -u root -p –events –ignore-table=mysql.event –all-databases > all_databases07.sql So what does it do: … Continue reading

Rate this:

Posted in Technical | Tagged , , | 2 Comments

Another Op’nin’, Another Show

Finally after a gap of approximately far too long, I am once again involved with a pantomime production (go on then, you know you want to – after three. Three – “Oh no you’re not”). Happy now? To be honest, at the … Continue reading

Rate this:

Posted in Personal, Technical | Tagged , , | Leave a comment

Earth v Martians (the 2nd leg)

No-one would have believed, in the last years of the 1970s, that Jeff Wayne‘s affairs were being watched by the tireless world of geeks. No one could have dreamed that his work was being scrutinized as someone with a maths … Continue reading

Rate this:

Posted in Personal, Technical | Tagged , , | Leave a comment

Tip: Jump to a random WordPress blog

If you’re looking to see what else there is out there, WordPress has a neat little trick up its sleeve. To jump to a random WordPress blog, simply use the URL  “http://wordpress.com/next/“. Try it for yourself, by clicking here, or simply drag … Continue reading

Rate this:

Posted in Technical | Tagged , | 2 Comments