Skip to content

Vettabase

Expert consulting and automation for your database infrastructure

Menu

Primary menu

  • Services
    • Monthly Time
    • Database Training
      • MariaDB
      • MySQL
      • Data Analysts Training
    • Health Checks
      • MariaDB
      • MySQL
      • PostgreSQL
      • Cassandra
    • Database Automation
    • Database Upgrades
  • Blog
    • Database Automation
    • MariaDB
    • MySQL
    • PostgreSQL
    • Cassandra
  • Resources
    • Ebooks
    • VettaArchive
  • About
    • Company updates
    • Testimonials
    • Partners
    • On the Web
    • Careers
    • Contact Us

Tuning PostgreSQL Auto-vacuum

Posted on 28 April 2022 by Michael Aboagye — 3 Comments ↓
Vettabase PostgreSQL Health Check

Why autovacuum is important in PostgreSQL and how to configure it properly. Continue reading Tuning PostgreSQL Auto-vacuum→

Posted in PostgreSQL | 3 Replies

How to fix git mistakes

Posted on 19 April 2022 by Federico Razzoli — No Comments ↓

Code or configuration versioning comes with a potential problem: fixing mistakes can be tricky. Here are some solutions for the most common problems. Continue reading How to fix git mistakes→

Posted in Database Automation | Leave a reply

MariaDB/MySQL: Working with MD5 or other hashes

Posted on 17 February 2022 by Federico Razzoli — 2 Comments ↓

The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes→

Posted in MariaDB, MySQL | 2 Replies

How to test database backups

Posted on 14 February 2022 by Federico Razzoli — No Comments ↓
Vettabase can help you implement Database Automation

Testing backups is often considered too expensive. But it is not, if the tests are adequately designed. Continue reading How to test database backups→

Posted in Database Automation, Strategy | Leave a reply

MariaDB: The regexp + LIKE optimisation

Posted on 27 January 2022 by Federico Razzoli — No Comments ↓

MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continue reading MariaDB: The regexp + LIKE optimisation→

Posted in MariaDB, MySQL | Leave a reply

A checklist for Database backup automation

Posted on 6 January 2022 by Federico Razzoli — No Comments ↓
Vettabase can help you implement Database Automation

Databases and technical debts: here’s a list of requirements your database infrastructure should have. Continue reading A checklist for Database backup automation→

Posted in Strategy | Leave a reply

MariaDB: WITH TIES syntax

Posted on 13 December 2021 by Federico Razzoli — No Comments ↓

Semantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax→

Posted in MariaDB Features | Tagged mariadb-10.6 | Leave a reply

How to delete duplicate rows in MariaDB

Posted on 28 November 2021 by Federico Razzoli — No Comments ↓

How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continue reading How to delete duplicate rows in MariaDB→

Posted in MariaDB | Tagged mariadb-10.2 | Leave a reply

The importance of maintenance windows

Posted on 25 October 2021 by Federico Razzoli — No Comments ↓

Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won’t be damaged. Continue reading The importance of maintenance windows→

Posted in Strategy | Leave a reply

The costs of using multiple database technologies

Posted on 3 October 2021 by Federico Razzoli — No Comments ↓

Before introducing a new database technology in your organisation, consider the drawbacks. Continue reading The costs of using multiple database technologies→

Posted in Strategy | Leave a reply

Post navigation

← Older posts

Primary Sidebar Widget Area

en_GB English
en_GB English it_IT Italian
Vettabase Ltd logo

Content License

Creative Commons License
Except where otherwise noted, the content on this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Recent Posts

  • Tuning PostgreSQL Auto-vacuum
  • How to fix git mistakes
  • MariaDB/MySQL: Working with MD5 or other hashes
  • How to test database backups
  • MariaDB: The regexp + LIKE optimisation

Categories

  • Amazon Redshift
  • Cassandra
  • Company updates
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB Features
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • Other Databases
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Strategy
  • Systems

Services

Check how Vettabase can maximise the efficiency and reliability of your database infrastructure!

  • Health Checks
  • Monthly Time
  • Training
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2022 Vettabase. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking "Accept", you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Cookie Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT