OptimizDBA Advice articles

sql performance tuning optimizdba
5 Ways to do performance tuning in SQL
SQL performing tools and techniques for the optimum performance of your database. Gone are the days when the data were stored in hard copies of files, now almost all the organizations use databases to store different data related to their operations. This has made databases very important for the operations of any organization, thereby performance … Read more
optimizdba database optimzation
Database Optimization: An insight
Data is the basic unit of any information transaction today. This includes everything present on the internet and off it. Large organizations have seen an exponential growth in their data network. This has increased the load on database systems. But, how to these database system cope up with the load? Optimization¬†is the key to the … Read more
optimizdba mysql performance
Optimizing the process of MySQL Performance Tuning
Released 23 years ago in 1995, MySQL, is still among the most popular relational database management systems. An open-source RDBMS, it uses Structured Query Language. And with the increasing amount of data, database management systems are a must-have for any organization. Now, as these databases expand, the data affects the processing speed negatively. To prevent … Read more
optimizdba.com database performance tuning
Tips to optimize your Database Performance tuning
  Data, as we all know is expanding exponentially by the second. Managing the data is more important than ever. Management includes setting up an efficient process to work with the data while assuring security. Relational databases are the modern-day answer to all your data management queries. But, database management systems sometimes need to undergo … Read more
optimizdba_SQLPerformanceTuning
SQL Performance Tuning
Data forms the backbone of any business. Irrespective of the type of the organization, there is always data that needs to be stored, manipulated, retrieved and displayed. Data can be stored in file systems, or a special software called as a database, whose sole purpose of existence is to organize and store data. Once data … Read more
data warehouse DBA
Data Warehouse DBA
A database administrator or simply a DBA is responsible for data, its availability, security and accessibility. The key responsibilities of a DBA include several things. These are not limited to Installation of software and maintenance. They also include data extraction and loading, handling, backup, monitoring, and database tuning.   However, owing to the ever-increasing amount … Read more
OptimizDBA MongoDB Optimization
MongoDB Performance: A Review For You
SQL is the language which forms the basis for most database management systems. Over the recent years, NoSQL has gained popularity because of its ability to handle and process multiple data types. Built using NoSQL, MongoDB is the most popular database management system. MongoDB is and open source software and has the ability to handle … Read more
OptimizDBA_Database_design
Relational Database: Best Design Practices
With the advent of big data and the increasing importance of data analytics, database management is more critical than ever. Every organization using a database management system appoints a DBA equipped to manage the resources and optimize the efficiency of the Database Management System.   Owing to the exponential increase in the volume and types … Read more
Database Administrator
Functions of a Database Administrator
With the constant rise of big data and its applications, management of databases has become a crucial process. Data has always played a major role and hence organizations invest extensively in Relational Database Management Systems (RDBMS).   But, running these systems is not an easy task and to effectively run and manage a database management … Read more
optimizDBA database optimization
MongoDB: The future of data?
MongoDB, one of the most powerful NoSQL database systems is an open source database management system which is document oriented and uses non-structured query language. Rather than using rows and columns associated with traditional DBMS systems, MongoDB has been designed to work on collections and documents. With an offbeat approach to data management, MongoDB has … Read more
MySQL v/s MariaDB
MySQL v/s MariaDB: Is There A Winner?
Database revolution took a new turn in 2010 when Oracle Corporation acquired MySQL. According to Michael Widenius, one of the original developers of MySQL, Oracle had a conflict of interest with their original Oracle database. Hence, his response to this situation was forking the MySQL project and creating MariaDB. The first version of MySQL was … Read more
Administrative challenges
Database Administration: Proactive or Reactive?
Database Administration: Proactive or Reactive? Being proactive can prevent many application related issues. When it comes to database performance, enterprises these days are looking for tools that can find potential vulnerabilities and threats. We will discuss the possibility of taking precautions concerning database administration. However, first, we need to understand that a significant part of … Read more