MySQL Optimization DBA

optimizdba Optimization1

MariaDB vs PostgreSQL: Know the difference between the databases

Posted February 25, 2019

SQL databases have played a vital role in the evolution of data storage and access. With these SQL databases, structured data could be stored and accessed very easily at scale, which has paced the enterprise operations. It was the SQL databases which formed the backbone of the online operations as the data was accessed at

Read More
optimizdba MySQL Data Visualization

Top MySQL Data Visualization Tools

Posted February 20, 2019

MySQL database has brought a revolution with them in the field of enterprise data. By enabling the enterprises to efficiently store and access data, with the MySQL database, things have evolved for good since the data keeping went digital. With the evolution in the database landscape, there has been a lot which has come up

Read More
Database Optimization Techniques

Database Optimization Techniques #3: Joins

Posted February 6, 2019

Increasing online presence has led to an emerging demand for reliable databases. With a lot of dependence on the database for the operations of the system, high performance of the database is always kept in high priorities. Any slowdowns in the database can affect the entire system’s performance. To avoid any disruptions in the operations

Read More
optimizdba Oracle consulting 1

SQL Server Extended Events vs SQL Azure Query

Posted February 4, 2019

SQL Server Extended Events vs SQL Azure Query Performance Insights: For SQL Performance Tuning Globalization and digitization of the enterprises have undoubtedly connected the world on the online platforms. This has also evolved the database landscape from being recorded in physical records to being uploaded on the databases, which are shared on the cloud. Enterprises

Read More