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 sql dba consultant

    Roles of an SQL server consultant for Enterprise Databases

    Posted December 19, 2018

    Databases have now been emerging into bigger and better versions, becoming an essential part of the operational systems. With the businesses and various institutions switching to the online mode for data storing and the scale of data which is growing massive, databases have become quintessential and substantial. Requirement of SQL consultancy services The enterprise data

    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