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.

CI/CD best practices
Applying CI/CD for deploying data-driven applications after migrating from Oracle to Amazon Aurora PostgreSQL
14 Feb 2020

The DB Best team designed and delivered a fully automated process driven by Jenkins. This process allows for a seamless deployment of data-driven applications after migrating them from on-premises Oracle database to the AWS cloud. Read the blog post to discover how we exceeded the customer’s expectations with our perfect delivery.

DevOps process Oracle Forms
Automating Oracle Forms and Reports conversion with a DevOps process
06 Feb 2020

The DB Best Oracle Forms and Reports Converter automates the conversion of your forms to a modern Web 2.0 architecture. Our converter processes the source XML files to JavaScript files and SQL code fragments. In this blog post, we will show our best practices for incorporating our Oracle Forms and Reports Converter into a Continous Integration (CI) / Continous Deployment (CD) DevOps process to shorten developer lead time and reduce change failure rates.

Database Compare Suite command-line interface
Automating data management operations with CLI scripts in Database Compare Suite
03 Feb 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 for data management tasks in the CLI mode. Why use Database Compare Suite in the CLI mode? This […]

DevOps blog post cover
How we strengthened a healthcare startup with DevOps
29 Jan 2020

In this blog post, we’ll cover the highlights of how we implemented DevOps technologies and managed to achieve zero downtime for the application deployments, eliminate a huge number of bugs by creating limitless development environments, shorten a full regression test cycle by a factor of 4, and enable a 15-minute infrastructure set up to replace their previous 4-hour set up!

Challenges migrating SAS solutions to SQL Server – Missing Values versus NULL
28 Jan 2020

Managers for a well-known accounting and tax-preparation company contacted DB Best looking for an alternative solution to a big problem. They were long term customers of SAS but were now facing two key challenges: high SAS license costs and the fact that SAS developers could not keep up with business demands and provide for effective support. The DB Best team analyzed our customers’ initial SAS solution and determined that the best possible option was to migrate their workloads to Microsoft […]

analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
27 Jan 2020

In this second blog post for my series, Power BI for the SQL Server DBA, I’m going to show how you can take Windows Perfmon (Performance Monitor) data for SQL Server and analyze it with Power BI.
I’m going to assume that as an SQL Server DBA, you probably have not used Power BI yet. If you have some familiarity with Power BI, I hope there are still gems you can pull out of this blog post.