Author: Tomas Helgi Johannsson

Tomas has over 20 years of experience as an Application Architect/Developer, Database Administrator, and Project Manager in a wide variety of business applications with a primary focus on performance. His main interest lies in client/server programming and distributed relational database design using DB2, Oracle, or MySQL/MariaDB.

Successful MySQL/MariaDB Backup and Recovery Strategies

Database administration, MySQL

A vital part of preventing any kind of data loss in any situation is having appropriate backup and...
Read More

Virtual Columns and Functional Indexes

Database development, Indexes, MySQL, Oracle, PostgreSQL, SQL Server, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Read More

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

Database development, Performance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution...
Read More