Welcome to Federico-Razzoli.com



I am a freelancer database consultant, specialised in MySQL and other open source databases.

Feel free to browse my free contents. My articles will help you in your job and will satisfy some of your curiosities.

Learn about me and my professional services. Please contact me for any question.


Important notice:
Because of the global health situation,
currently all Database Consulting services take place remotely.


Knowledge Base

Federico-Razzoli.com articles aim to form a shared knowledge base on open source database systems. Feel free to read, contribute with comments, and share links to these contents.

Setting performance and availability objectives (SLO)

Setting performance and availability objectives (SLO)

How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it. ...
Dropping database objects in a safe way

Dropping database objects in a safe way

Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables ... ...
Circular tables in MariaDB

Circular tables in MariaDB

Let's create a table that always contains a fixed amount of rows, using MariaDB 10.3. ...
The perils of ALTER TABLE in MySQL/MariaDB

The perils of ALTER TABLE in MySQL/MariaDB

ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let's discuss the problems that one has to take into account. ...
What does NULL mean in SQL?

What does NULL mean in SQL?

Does NULL mean "no value"? Or does it mean "an unknown value"? Its semantics and history are ambiguous and inconsistent. ...