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

16:32 Database administation

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

12:06 Database development, Indexes, 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

14:49 Database development, Perfomance 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