Relational Database Query Optimization

We’re discussing query optimization techniques for relational databases, covering both common and uncommon strategies across various database management systems. These techniques range from basic practices like indexing to advanced methods like bitmap indexing and adaptive cursor sharing. Continue reading →

MariaDB & SkySQL DBAAS

Starting to use, or interested in using MariaDB? This is a getting started post that will get you started with MariaDB and SkySQL. Prerequisite knowledge of SQL is helpful, but I step through every single little detail in this post to get you up and running, with a good context of what you’re getting. Continue reading →