Yes, everything is temporary; it just depends on the timescales.

Getting rid of Microsoft at the...

Apparently, France is one of the few nations that can design and build its own fighter jets alone.  It's a great shame because the UK used to be really good...

There is no magic; it is what we are taught to focus on.  The original two SQL Server 6.5 courses (admin & developer) showed us execution plans, Perfmon, profiler and...

Technology runs ahead of what CTOs and architects can keep up with.  By the time they have assessed it, the cat is out of the bag.  It is very hard...

I hate mono repos. I think that's how we often "re-used" code in the past, sometimes with a Windows, Android, and iOS apps in the same repo. (though often...

Back when I had to do database deployments, we would rehearse the deployment and rollback twice, checking that we had actually achieved both.

Our approach evolved over the years.  A deployment...

I used GitHub Co-Pilot as an initial reviewer, but not an approving reviewer.  It would raise points on a pull request that were the sorts of questions that a junior...

There are some good points here.

Getting realistic production data is the bane of my existence.  Generating data is easy.  Generating data that represents what happens in Production is not.

We have...

Having read LinkedIn recently, I think someone implemented something similar for real.

I recommend watching the video on https://github.com/github/spec-kit.

I'm in two minds about the new world.  On one hand, it encourages us to be more hands-off, more managerial.  On the other side,...

I inherited a data pipeline with a daunting amount of infrastructure, code, database artefacts, and huge volumes of logs.

I found that the CICD pipeline was creating artefacts for each run...

The whole world runs on hidden heroes in all endeavours.  An awful lot of stuff works because someone quietly did a thankless task, sometimes in the face of hostility from...

I am using Snowflake, which has several timestamp data types.  It's a legacy codebase, so usage across the codebase is a bit random.

• TIMESTAMP_LTZ  stores UTC, but any interaction will...

I'm a Principal Data Engineer.  One of the things I do is to look at what other principals are doing in their areas and weigh the pros and cons of...

Brent's point is backed up by the theory of constraints.  The theory is that you only have one critical bottleneck constraint at a time.

The more impressive motor racing feat is...