How To Maintain MPP-Based Referential Integrity (RI)?

How should we maintain referential integrity in an MPP data warehouse?
Data Warehousing Is More Than “Modern Data Stack & Raw Data”

Does ChatGPT align with Bill Inmon’s thoughts on Data Warehousing?
Make SQL Your Data Friend

Is SQL your best data friend?
Punching the Numbers

Round One: We’re stepping into the octagon on the front foot with one question: What’s the real value of data in MMA? In this post, we’ll take a closer look at the UFC (Ultimate Fighting Championship) and explore how fight data and analytics are shaping the sport. From breaking down fighter performance stats to showing […]
Can You Measure Love? Analysing “I Love You” with Data

Recently, on a sunny Easter Sunday, I took the plunge and “put a ring on it” as all of the cool kids say these days. A day that I thought would never come, but after a whirlwind twelve months my partner and I are now engaged! So, of course, you would think my next step […]
The Exploration of Programming Languages – Standards of a Coder

Having been involved in IT for 30 years I have often been left bemused by the standards used by some programmers and sometimes imposed by programming languages. I started on Cobol. There were strict naming standards for file division, working storage and linkage section variables so you knew what you were dealing with.Indentations were mandatory, […]
30 Years In I.T. …You’d get Less for Murder!

A few weeks ago marked 30 years since yours truly started out as a graduate IT trainee at Royal Insurance (now RSA) in 1988. Back then, there were no PCs, just dumb terminals; no mobile phones, just landlines; no email, no internet. But the biggest shock of all: other people could smoke at your desk! […]
Gaming, Data, and Behaviour

From time spent in certain game modes, to player damage with weapons, and how players move around maps, video game developers have had access to a wide range of telemetry data for years now. They’ve been using this data to refine the core feedback loops they use to keep players engaged and coming back for […]
Technology, Prediction, and the Problem of Change

Mini-disks, Sabre-toothed Chickens and Pizza Grease – a Deadly Serious Discussion of Technology and Prediction. “All fixed, fast-frozen relations, with their train of ancient and venerable prejudices and opinions, are swept away, all new-formed ones become antiquated before they can ossify. All that is solid melts into air…”— Karl Marx, The Communist Manifesto (1848) When […]