The mechanics for this are relatively easy.  The hard bit was the thinking to make it relatively easy.

We have a small CI/CD database that holds some data that we expect...

There have been supply chain attacks on PyPi that have resulted in popular Python packages being compromised.  Getting the timing right for patching is vital

• Too quick = Risk exposure...

I never got to use Analysis Services.  My company had me stretched with my workload and learning the parts of SQL Server relating to that workload.  At the time, I...

I am reviewing a PR where AI has been used extensively.

In terms of functional requirements, it works.

In terms of NFRs, such as maintainability, code quality metrics, sensible variable names, well-structured...

Where is the borderline between a script and a tool?

Most of my development work is done on a Mac configured to use the ZSH (Z Shell) with https://ohmyz.sh/

We do a...

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,...