SQL Server Optimization

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

5 Ways to do performance tuning in SQL

Posted October 25, 2018

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 August 20, 2018

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 August 5, 2018

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