SSIS controlling framework
Using Azure DevOps and PowerShell to automate testing of SSIS packages
March 11, 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. […]

Wellness watch application
March 11, 2020

Remember the day Apple Watch was released and how it stormed through the market in April 2015? Now, wearables have become a significant part of our lives —  and if a phone manufacturer wants to be competitive, there should be fitting smartwatches to back its claims. The importance of Apple Watch reflects a general trend, as the Apple ecosystem is among the main reasons for iPhone’s popularity. Creating a wellness app makes perfect sense. Smartwatches are on the forefront of […]

Adding a test automation framework into a database migration CI/CD pipeline
March 03, 2020 , Olga Ievdokymenko

As your solution grows together with the number of users, it becomes more challenging to launch updates timely. A manual tests-driven QA process drags down new deliverables. Now it takes your team days to cope with batch-job testing and weeks for an overall regression cycle. You have to pay more for the QA and hope for your users to be patient while waiting for fixes and updates. Oops, that’s a slippery slope!

In this blog post, we’ll tell how we built a solid test automation sequence running on AWS. This allowed our client for regular deliverables and shortened spending for testing. At the final, the DB Best covered 70% of apps with automated tests and reduced regression time from 5 days to 5 hours.

Rental car mobile application development
February 26, 2020

The world has over a billion cars and not of them are being used. Some people have older vehicles, some don’t have time for using them but both the categories have a common thought — why not lease it and make a quick buck out of idle cars? Luckily, there are always people willing to rent cars for trips and DB Best connects these people together. The long-reaching app nature allows for attracting customers from all around the world to […]

Invoke-Sqlcmd variable parameter
Using PowerShell Invoke-Sqlcmd with Variable parameter
February 24, 2020

I recently needed to use PowerShell to call a T-SQL script using Invoke-Sqlcmd with the -Variable parameter. In my case, I wanted to specify the locations for backup files and where to restore the data and log files. Rather than add the conditions into the SQL script, I wanted to make the SQL script as generic as possible, and use SQLCMD variables for the different scenarios. In this blog, I’ll show how to use the array sub-expression operator and “splatting” […]

Migration Platform update
Improving the Test Organizer module of the DB Best Migration Platform
February 13, 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. In this blog post, we will cover these new application features, however, we recommend you starting with our previous blog posts: A typical workflow of the DB Best Migration Platform Using the […]

ML in construction blog post cover image
Eliminate safety breaches in construction with ML algorithms
February 11, 2020

In this blog post, we describe how we developed a solution to prevent the most common safety breaches in construction. The solution combines machine learning algorithms and computer vision technologies to detect workers not wearing helmets analyzing video materials. Our algorithms reached 98% accuracy, and we’re proud that the solution actively used by our customers.

Integrating machine learning into ETL processing for data cleansing
January 30, 2020

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

Test automation blog post cover
Integrating TestNG and Appium for mobile app test automation
January 28, 2020

Today we start a blog post series showing how to incorporate automation testing for different industries. This includes mobile healthcare applications with a lot of connected devices, complex database migration projects, and huge enterprise-level desktop multiplatform products. This blog shows how we used the TestNG and Appium frameworks for mobile app test automation using a CI/CD pipeline. The result was a 3.6 times reduction in testing person-hours and a reduction of the full-regression test cycle time by 25%.

Database Compare Suite command-line interface
Automating data management operations with command-line interface of Database Compare Suite
January 23, 2020

We continue our blog post series covering key Database Compare Suite (DBCS) features. In our previous posts, we talked about comparing data and discovering data differences by leveraging the user interface of Database Compare Suite. The command-line interface of our product provides users with all the features of the main application. In this blog post we will talk about using Database Compare Suite in the CLI mode. Why use Database Compare Suite in the CLI mode? This approach allows for increased […]