SQL Server Optimization Archives - Databases Optimization Experts | OptimizDBA |optimiz DBA

optimizdba Oracle consulting 1

SQL Server Extended Events vs SQL Azure Query

Posted

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
optimizdba performance monitor

How to improve database performance in SQL Server?

Posted

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
sql performance tuning optimizdba

5 Ways to do performance tuning in SQL

Posted

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
MySQL v/s MariaDB

MySQL v/s MariaDB: Is There A Winner?

Posted

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
5 Strategies for Performance Tuning in SQL Server

5 Strategies for Performance Tuning in SQL Server

Posted

Performance Tuning in SQL Server involves identification and execution of error correcting strategies to improve application performance. The scale of enterprise databases makes it a challenging task to locate the erroneous components and strategize a solution that best suits the organization’s needs. Over the years that we have worked with large organizations, we have identified

Read More