Using Azure DevOps and PowerShell to automate testing of SSIS packages
28 May 2020

One of our customers aimed to modernize their on-premises project and replace the aging AS/400 system with Microsoft SQL Server. Having an enormous amount of code, the existing program was almost maintainable and cried for a smart solution. DB Best developed a brand-new way to manage epic projects. We required a smart solution to optimize costs and streamline the process. Our team leveraged the latest DevOps practices to create a solution that allows for managing the epic systems in layers. […]

Utilize Machine Learning to double the retail sales
22 Apr 2020

Every retailer knows that product position within their store has a direct influence on revenue. But how do you apply this knowledge? Would you win more by selling a batch of cheaper goods or a few high priced items? Will the product placed on the same position in two different outlets get equal attention from the consumers? DB Best leveraged neural networks and machine learning algorithms to develop a solution that allows for increasing sales and doubling the retailer’s revenue […]

How we improved customer analytics with machine learning algorithms
16 Apr 2020

For retail businesses with distributed point of sales (POS) systems, you can often run into the problem where stores fail to synchronize their data with the centralized data warehouse. If you are not aware of this situation, you can end up taking faulty business decisions when making seasonal adjustments for your supply chain. The top-selling product for the last week at a given store ends up not getting resupplied. Even worse is when last week’s hot seller, no longer is.

In this blog post, we’ll discuss how machine learning anomaly detection for retail POS systems can identify sites that fail to consistently report data into a centralized data warehouse.

Backup Improvements and Errors Handling for DB Best Migration Platform
15 Apr 2020

DB Best has released a new version of Migration Platform, a well-rounded program for automating database migration processes. This newer 1.2 version improves error handling practices for Test Organizer by creating additional mapping rules for matching different error messages and codes. We also added the partial data backup and restore functionality along with the capability to add and remove tables from existing datasets for the Data Store module. On top of that, we enabled command timeouts for several major modules.

Eliminate safety breaches in construction with ML algorithms
10 Apr 2020

In this blog post, we describe how we applied our knowledge in machine learning and computer vision to prevent one of the most common safety breaches among builders. The DB Best team came up with a solution utilizing the YOLO object detection algorithm for a neural network to detect those not wearing hard hats on a construction site. Our algorithms reached 98% accuracy in identifying troublemakers analyzing video materials in real-time!

Database Compare Suite 5.2 brings MariaDB support
07 Apr 2020

DB Best has released a new version of Database Compare Suite. This version supports MariaDB, a popular fork of MySQL database platform. Another major improvement of the latest release is virtual views. Read this blog post to discover how to use these data objects and when you need to create them.

Test automation website cover
Integrating TestNG and Appium for mobile app test automation
05 Mar 2020

For mobile healthcare applications with many connected devices, complex database migration projects, and huge enterprise-level desktop multiplatform products, a solid DevOps environment is critical. In this blog, we’ll show how we used the TestNG and Appium frameworks for mobile app test automation using a CI/CD pipeline. We’ll also look at how we used AWS CloudFormation and PowerShell to deploy the test environment as well. The result was a 3.6 times reduction in testing person-hours and a reduction of the full-regression test cycle time by 25%.

Integrating machine learning into ETL processing for data cleansing
03 Mar 2020

This case study features our experience of measuring data science algorithms to optimize the ETL processing for data cleansing.

Invoke-Sqlcmd variable parameter
Using PowerShell Invoke-Sqlcmd with Variable parameter
26 Feb 2020

In this blog, our Chief Technology Storyteller Bill Ramos shows how to use the array sub-expression operator and “splatting” with hash tables to build the parameters needed for the Invoke-Sqlcmd cmdlet.

Migration Platform update
Improving the Test Organizer module of the DB Best Migration Platform
20 Feb 2020

DB Best released a new version of Migration Platform, our ultimate product for automating database migrations. In this release we added new features to the Test Organizer module, a unique and unrivaled feature of the DB Best Migration Platform. We also made several improvements of the user interface. Read this blog post to learn more about these new application features.