by Javier Morales Carreras | Oct 11, 2023 | GitHub projects
This one is about bad practices. The use of synonyms. If you have felt a cold sweat, you probably experienced something similar. Many users want to access application tables “transparently.” Note that I put it in quotes because calling...
by Javier Morales Carreras | Mar 2, 2023 | GitHub projects
As every year, it’s time to clean up the databases Marie Kondo style. Database administrators have to historicize, compress or delete old partitions that are no longer needed. Obviously, partitioned tables (and their local indexes) are the best place to...
by Javier Morales Carreras | Jan 22, 2023 | GitHub projects
Let’s talk about physical backups and how to get a report based on your own “safety criteria” about the successfull backups needed to ensure a safe recovery scenario. In many places, they get reports when backups end successfully, or sometimes only...