If production data is something like sensor data with no personal or personally identifiable (PII) data then replicas of that data are useful for a number of purposes. But sensors...

I've seen a repeating pattern throughout my career that is effectively a hype cycle.

• New technology is trumpetted from the roof tops as being the greatest thing since sliced bread

...

BigQuery has a data type called STRING with no size specification.

In Snowflake all text columns are VARCHAR under the hood, including CHAR.

For pure column stores the method of encoding probably...

I think the important thing is to reflect on the lessons learned and ask what we would do better with the benefit of hindsight.

• Environment not available in the same...

I've joined the Great Resignation.  To be honest, I wish I had done so 3 years ago.  For me the COVID situation and having to work remotely highlighted something I...

Alex Yates has some strong opinions on DevOps engineers and I'm broadly in agreement with him.  My experience is that DevOps has become synonymous with a team responsible for spinning...

I think GO (GoLang) is a good one to learn.  It was designed to balance fast compile, fast execution and ease of use.

It has its unit test capability built in...

There's a story about two people doing separate presentations to a government official using the same base statistics to argue contradictory cases.  When challenged the 2nd person replied "Ah well,...

I've just moved on but in my previous position we had a single sign on application into which all our systems were integrated.

Before you could sign on to anything you...

I feel the point on accidental complexity is especially important. Dr Venkat Subramamian gives some fantastic talks on the subject  https://agiledeveloper.com/aboutus.html

I also think that premature optimization and failing to understand...

Excellent advice.

I'd also add that Brent Ozar, Pinal Dave, Grant Fitchey, Catherine Wilhelmsen, Steph Locke, Jen Stirrup and many others are highly visible in the DB community.  Such involvement brings...

Do you have any recommended technical sites that require subscription?

I'm a bit paranoid about signing up to a site that turns out to be heavy on clickbait and really difficult...

Excellent article, very interesting linked articles too.

What do people do to come back from burnout? Asking for a friend

The difference between on premises and IaaS is that your on premises hardware may be higher grade and less prone to failure. I'd encourage anyone migrating to the cloud to...

Our systems are predominantly cloud native.  For data warehousing handing someone else the headache of exponential data growth is extremely attractive.

Our infrastructure manager said that one of the attraction of...