James's Weblog

If you run an application that includes a database, you want to be taking backups regularly. Your backup needs to include tables, views and triggers. It must also include any stored procedures / routines you are using. Otherwise, when you restore from backup, your procedures will be missing.

This article is not about Microsoft SQL Server. This concerns MySQL and its forks MariaDB and Percona.

I've found lots of people asking this question on the web, but not many of the posts I've found have a working answer.

Where the North Sea meets the Atlantic lies a small country, the United Isles of Great Britannia (GB for short)

It is often reported that New Zealand has more sheep than people. GB has more cats than people – they are a nation of cat-lovers. As a result, a thriving industry in veterinary medicine has developed.

Yesterday, the Church of England published a press release summarising the proposals being brought by the college of Bishops at the end of the 6-year consultation process on same-sex marriage. This included a series of national conversations (tautologically, "shared conversations"), which took place at the General Synod and locally, and a course and set of resources branded "Living in Love and Faith".

The second of two blog posts looking at how the S&P 500 performance one year impacts what happens in the following year. The first post just looked at how many years saw the index decline or increase. In this follow-up post, I look at the actual figures: By how much did it go up or down? Does this more detailed analysis show any patterns that we previously dismissed?

A Bloomberg article at the end of 2022 made the claim that after a negative year for the S&P 500, the following year is relatively unlikely to follow suit. This post looks at the statistics to see whether such a claim holds true. We also look at other claims they made about what happens when you do get two bad years in a row: is the second year worse than the first, and will a third bad one follow?

A thought on why Ezekiel 40-48 are such important chapters.

The other day I was reading 2 Chronicles 6:36-39, the prayer that Solomon prays when he dedicates the new temple he's just built. If the people are exiled, they can pray towards the city and the temple and God will hear.

Yesterday evening, I had the joy of being invited to our church midweek youth ministry. The teenagers had been given the chance to write down questions they'd like to ask one of their pastors, and I was invited along to tackle those questions and any others that came up during the course of the evening.

Currently, my anti-virus software of choice is Bitdefender.

There's a file on a Windows computer called the "hosts file", that most people have no need to change. It lives at c:\windows\system32\drivers\etc\hosts. (Linux-based systems have a hosts file too, at /etc/hosts.) In fact, unless you have a need to change it, and know what you're doing, leave well alone.

The parable of the lost sheep occurs in two of the gospels: It's in Matthew 18:10-14 and Luke 15:1-7.

This is one of those posts where I stick something on here to help me find it again, and because I won't be the only person trying to solve this.

The Problem: Size and Position of Individual Messages

Microsoft Outlook (msoutlook) is an email client, part of the Microsoft Office suite, and available as part of the Office 365 subscription. Do not confuse this with their online Outlook email service, which is the successor of Hotmail.