How to find useless indexes and get rid of them to improve your database performance.
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
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 …
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.