SQL Server – quickly delete all tables

October 12, 2018 Matt Thornton 0

With most things in SQL Server it’s tempting to think you can script it. Because most of the time you can. Recently, I had a requirement to quickly drop everything out of a database (but without actually just dropping the whole database.) The best option I found, was: 1) In […]

Recovering files from broken Raspberry Pi – Part 1

December 5, 2017 Matt Thornton 0

I have a Raspberry Pi 3 which serves solely as a MySQL server. It does have an important (production-esque) purpose but despite that… I didn’t have it backed up properly. Oops. So when it spectacularly died the other day, and, um… production things… stopped productioning… I worried a little. Well […]

MySQL table name case sensitivity

October 1, 2017 Matt Thornton 0

Just encountered a fun little issue when trying to move something from a local MySQL server to a ‘Prod’ server. The difference in architecture being that dev MySQL was running on OSX whereas the ‘Prod’ MySQL was running on Linux (debian). The issue was that a lot of my queries/views/procedures […]

gnucash + mysql + OS X 10.10: getting it running

April 7, 2015 Matt Thornton 0

This post will help you to get gnucash running with MySQL on OS X 10.10. Background I do the bookkeeping and accounts for a variety of small NFPs or charitable organisations. I recently moved my bookkeeping for these from a combination of Sharepoint (seriously) and SSRS and Excel in to […]