General

Whenever we’re talking about an amount of data, it’s important to understand the units that are used. In all the early days of computing, it all seemed pretty simple. We had KB for 1024 bytes, MB for 1024 * 1024 bytes, etc.

The first people I saw messing that up were the hard drive manufacturers. Originally, they followed the standard units that we had been using in computing. But somewhere along the way, they changed how this worked. The vendors decided that if they had 10,000,000 bytes of storage, they would call that a 10MB hard drive, but of course it wasn’t, at least not in how we used to measure them. Some of the vendors even started talking about hard drive megabytes like it was some other new unit. That meant that suddenly a 128MB hard drive (128 * 1024 * 1024 * 1024 or 137,438,953,472 bytes) became a 137MB hard drive.

2026-03-25

I was part of a discussion the other day where the topic was the most misleading error message you’ve ever seen. I’ve been in the industry long enough that it’s a pretty tall list of error messages that I need to consider.

The winner for me

But I finally decided on one:

Back in the VB6 days, there was a common error message that said Out of Memory.

There were many issues that could lead to that error message, but running out of memory was probably the least likely.

2026-03-23

Over the years, I’ve seen so many discussions regarding the certification process and exams. I’ve seen posts from many people that are very experienced with products saying they can’t see any point in the certification exams and also argue that competencies in the Microsoft Partner program shouldn’t be based on exams. They feel these people should somehow just be recognised for their other contributions.

Grandfathering

Regarding the certification process, I don’t agree that anyone should be just grandfathered in. Any of the people that have a great deal of knowledge and experience really should be able to just take the exams and be done with it.

2026-03-17

Something I really struggle with in this industry is when newcomers to a system want to change standards within existing systems because they think something else is better. It’s a sign of immaturity yet it often applies to people who should be senior. Many system architects fall into this category.

What’s in a PK name?

For example, a vendor system that I’ve been working with has single column primary keys in all tables, and all the primary key columns are named PKey_ID (I’ve changed it a bit to protect the guilty). Now I can’t say I like that naming at all, but that’s not the point. There are a large number of tables that already have that naming scheme.

2026-03-15

There is a hotel in Sydney that we often stayed at several times per year, either for training or mentoring/consulting work. I really like it. If you asked me why though, I would find it hard to list all the reasons why I like it. (There are some things I don’t like about it too but that’s a topic for another day).

But one of the things that had always surprised me, each and every time I ate breakfast there, is how sharp the knives were. It might seem an odd thing to notice but I’ve never noticed this in any other hotel that I’ve ever stayed at.

2026-02-21

It’s Chinese New Year this week, and I want to offer my best wishes to all my readers that celebrate the lunar new year.

新年快乐 ！(Happy new year)

It’s the start of the year of the Fire Horse.

The start of a new lunar year is a time of renewal, reflection, and optimism. Across the world, families and communities are come together to celebrate with traditions that emphasise good fortune, gratitude, and fresh beginnings.

2026-02-17

A while back, I got an interesting reply to a blog entry about LINQ and Entity Framework terminology. The reader asked if I’d worked with the Progress DBMS.

I have.

Here are my thoughts on it. Obviously others will have a different view of history but I mention Progress over and over again when I’m teaching classes as three examples related to them really hit home for me.

Background

I worked with Progress for many years, starting in about 1983 through to some time in the late 1990’s.

2026-02-07

Crocodiles fascinate me. They’ve been around since the dinosaurs, and until we came along and made weapons, they were a top-tier predator.

Recently I watched the end of a wonderful documentary from the BBC called Dragons Alive . Although my wife didn’t really want to discuss it at 12:30am, it really got me thinking about the nature of curiosity and its importance in how we advance science and through it, society.

2026-02-05

When government funding is tight, it gets harder and harder to get grants to perform fundamental research. The government always wants to see outcomes, and this means that the grants committees need to show outcomes. In turn, this often leads to research funding bodies doing one of three things:

• Only funding research that’s nearly complete
• Only funding well-known researchers with a track record of outcomes
• Only funding research in areas that are already showing promise

Now while at first glance, that might sound a reasonable way to proceed, it’s not.

2026-01-22

So 2025 is done. It was both an interesting and a challenging year for me. I’m so glad for all you who have been reading my blog and hope you’ll continue into the future.

What Will Matter Most for Data Professionals in 2026?

As a new year begins, it’s a good time to pause and look ahead — not with hype or predictions, but with a practical view of what will genuinely matter for data professionals in 2026. Across consulting projects, training course development, and hands-on work with SQL Server, Microsoft Fabric, and modern data platforms, several patterns have emerged that are shaping how teams build and operate data solutions.

2026-01-01