How to remote duplicate values from a table to add a UNIQUE index, in MariaDB.
Vettabase Blog
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won't be damaged.
Before introducing a new database technology in your organisation, consider the drawbacks.
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Some queries always fail or never return rows. They should be eliminated to improve database performance.
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.
Choose the best balance between speed and consistency by setting proper consistency levels.
Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.