Home

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.
CodingSight - Successful MySQL/MariaDB Backup and Recovery Strategies

Successful MySQL/MariaDB Backup and Recovery Strategies

April 06, 2021• 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

January 13, 2021• 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 →
CodingSight - How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

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

November 20, 2020• 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 →
↑
Close