MySQL Optimization DBA

optimizdba performance monitor

How to improve database performance in SQL Server?

Posted November 26, 2018

With the businesses gearing up to online platforms such as websites and apps rather than being operational from brick and mortar offices, there has been a rising requirement for software infrastructures such as Databases. Database marks an essential part of all the online products and services, and that is why having a high performing database

Read More
optimizdba database optimization

Top 5 challenges for 2019 in database optimization

Posted November 15, 2018

Database Optimization Challenges Big Data is the next big thing and with the advent of such a vast amount of data, database management has seen an exponential rise. This means more technological advances and thus, the need for better database optimization.   To tackle the data and increase efficiency, database administrators are constantly being asked

Read More
optimizdba mysql database tutorial join and view

My SQL Database Tutorial: Views and Joins

Posted November 12, 2018

Introduction In this MySQL database tutorial, we will learn more about Views and how to perform joins efficiently. Database View Database Views are essentially SQL (Structured Query Language) query with an associated name. Views can frequently be used in the queries by selecting the desired rows or the columns of a table. They can instantly

Read More
optimizdba databases

SQL vs NoSQL: The Pros and Cons

Posted November 5, 2018

Big data is a word which is very common in the modern day with every industry giving it a lot of importance. It is simply because of this exponential increase in data that every organization is paying attention to data management. It is for this reason that debates often get heated when it comes to

Read More