Valérian de Thézan de Gaussan · Freelance Data Engineer

All my blog posts, by date.

Be cautious, as you might acquire forbidden knowledge that could render you excessively powerful.

A simple mnemonic to optimize your SQL queries.

Easy to remember, featuring squirrels 🐿️

Stop using complicated technologies to solve simple problems.

Here's how I built in 5 minutes a data pipeline for a simple extract-transform-load process.

CoderPad released a "State of the Tech" 2024 report.

It highlights an encouraging trend towards freelancing within the industry.

The two-fold cost analysis that I use for any data infrastructure.

It yields a lot of value by mostly removing stuff.

No more Talend Open Studio. What should you do?

Qlik announced that Talend Open Studio, the non-commercial version of Talend Studio, will be discontinued by January 31, 2024.

"It just takes this to do that": Oh, really?

Have you noticed? Those words that slipped in?

Those who understand this concept will own 100% of the software development market share by 2030.

It's about the principle of resource efficiency vs flow efficiency in Lean.

Inexpensive Data Platform

Don't let yourself be fooled by crazy engineers.

Introducing a developer toolbox.

One more in an ocean of toolboxes.

Programmation orientée objet

(French) Cours de Programmation Orientée Objet avec exercices.

Agility: an analogy

An analogy to keep in mind in all your discussions about agile software development.

The one bug every Python developer will encounter once.

An annoying bug with Python that can be easily avoided.

The three great pillars of a data system.

Resiliency, Scalability, Maintainability

The bold truth about agile in IT projects

The IT project management world suffers the same issues as the climate.

Starting a Software Project Right

It just requires a one-page document.

The first question to ask when requested a new feature

It is not 'When this needs to be done'

About removing code

I'm in the business of deleting code, not just writing it.

The only Thing that Matters is Priority

Focusing on priority is a simple yet effective way of reducing waste in project management.

On the importance of tests in software.

Did you know that 50% of developers never conduct any tests?

Turning legacy code into gold.

Embracing the challenge for profitable outcomes by avoiding cynicism.

The role of the Data Engineer.

The role of a Data Engineer is often misunderstood.

The database is not the center of your application.

Your use-cases are. The database is a dependency and should be treated as such.

Failure Case Study #2: How to lose $400 million.

Here's how to avoid following Nike's path to a $400 million loss.

Advice for devs who want to build strong ETLs.

4 actionable best practices to start writing solid code.

Don't estimate.

Let me help you estimate your tasks.

Paying technical debt vs adding business value.

If you don't care about technical debt, read this to understand how it impacts indirectly your business.

Failure Case Study #1: The error made by French television the night of the election.

For 2 hours and 40 minutes, wrong numbers were displayed. Here's how to avoid making the same mistake.