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 times when users start noticing performance issues. Amazon introduced a feature called Redshift Optimization for the...

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: (more…)...

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.  (more…)...

SQL Server Performance Tuning: Controlling Parallelism Webcast
03 Aug 2015

Free Webcast 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 know how to tweak the settings to make it run optimally. When parallelism goes awry, it can cause severe performance problem...