Learn more about
Improving the performance

Talks on Managing Data and Applications Anywhere

Amazon Redshift Performance Tuning Tips
Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 Dec 2017

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution […]

Increase database performance while migrating to SQL Server
Increasing database performance by migrating from Ingres to SQL Server
18 Jul 2017

One of our customers needed to migrate their Ingres Database system to Microsoft SQL Server wanting to improve the performance of their system. We came up with a migration solution and updated the business logic module of their application. As a result, the customer achieved a sufficient performance increase, improved the database system security, and got an optimized business logic architecture. The video below depicts the migration process in details:

Enhancing SQL Server database performance by 3x acceleration of queries execution
Enhancing SQL Server database performance by 3x acceleration of queries execution
06 Jul 2017

A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performance issues and needed an efficient solution to resolve them. We analyzed the customer’s system and delivered instructions with detailed descriptions. They covered all discovered issues and described the possible approaches to fix them. With our instructions, our customer achieved more than three times better overall query performance. 

SQL Server Performance Tuning: Controlling Parallelism Webcast
03 Aug 2015

Join Robert L Davis, Principal Database Architect at DB Best Technologies, for a free webcast through MSSQLTips.com on Thursday, August 13, 2015. Robert will be presenting SQL Server Performance Tuning: Controlling Parallelism. Webcast description: Parallelism seems like it should be one of those things that the query engine takes care of for us, but it does require some care and tending from time to time. The default server configurations are no longer adequate for controlling parallelism, and DBAs need to […]