How to fix git mistakes



Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continua a leggere How to fix git mistakes
Expert consulting and automation for your database infrastructure
Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continua a leggere How to fix git mistakes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continua a leggere MariaDB/MySQL: Working with MD5 or other hashes
Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continua a leggere How to test database backups
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continua a leggere MariaDB: The regexp + LIKE optimisation
Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continua a leggere A checklist for Database backup automation
Semantics and use cases of the WITH TIES syntax. Continua a leggere MariaDB: WITH TIES syntax
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continua a leggere How to delete duplicate rows in MariaDB
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continua a leggere The importance of maintenance windows
Before introducing a new database technology in your organisation, consider the drawbacks. Continua a leggere The costs of using multiple database technologies
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continua a leggere How slow is SELECT * ?