DevOps process Oracle Forms
Automating Oracle Forms and Reports conversion with a DevOps process
03 Jan 2020

The DB Best Oracle Forms and Reports Converter automates the conversion of your forms to a modern Web 2.0 architecture. We use the Oracle provided FormModules, ObjectLibraries, or MenuModules to XML command-line tool called Forms2XML along with the corresponding Oracle Reports convert to XML tools to start the process. Our converter then 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 […]

SQL Server statistics update
Improve SQL Server statistics update 1000 times faster than traditional approaches
22 Aug 2019

One of the customers contacted DB Best to help address performance issues with their SQL Server application. They started experiencing problems after upgrading from SQL Server 2008 R2 up to SQL Server 2016. However, after we analyzed their database system, we discovered a complex issue with updating SQL Server statistics.
We utilized industry best practices and internal expertise to correct issues. Read our blog post to learn how we approached this complex task.

setting up SQL Server on Linux
Greater performance with lower cost with SQL Server on Linux Data Warehouse
21 Aug 2019

What do you do when your data science team needs to perform read-only data warehouse queries against your mission-critical online transaction and batch processing database? Our customer Getty Images had exactly this problem with their production AWS deployment of SQL Server 2014 AlwaysOn on EC2 instances. Their data science team was performing read-only queries over 4 terabytes of historical data. These queries are ad-hoc and look at multiple months of historical data for analysis. The queries would consume all available […]

Docker
DevOps and test automation: Docker saves the day!
06 Aug 2019

Recently, the DB Best team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to leverage Docker to automate the environment set up.
In this blog post, we will share our experience with using Docker for automating a NoSQL database migration dev/test environment.

remove the Management Data Warehouse from SQL Server
How to remove the Management Data Warehouse from SQL Server running on a production instance
26 Jun 2019

One of our customers had their Management Data Warehouse (MDW) running on their production SQL Server 2012 and didn’t know what to do with it. Microsoft had introduced the MDW with SQL Server in 2008. However, there was a bug in SQL Server 2012 that prevented the Query Statistics data collector from working. Rather than trying to fix it, we made the decision to remove it instead.
Removing the MDW from SQL Server running in production is straight forward and requires that you follow the steps described in this blog post.

business intelligence strategy
Building a new business intelligence strategy that really adds value
14 Mar 2019

What do you do when you’re one of the global leaders in the beauty industry and your growing data environment is getting out of control? You set up a call with DB Best and start to speak with one of our dedicated Project Managers. We began with just a single developer working with this customer but very soon it grew to include an additional 13. After 5 years, what started as a data environment analysis has grown to a full […]

Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
25 Jan 2018

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormously huge database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. DB Best provided the customer with the day-to-day operational data management services both on-premises and in the cloud, as well as configured the new architecture for their cloud-based system. Discover the benefits […]

Performing a comprehensive SQL Server Database Health Check
Getting the most out of a comprehensive database health check for SQL Server
22 Aug 2017

One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we found several high priority issues which required immediate actions. In addition, we provided the customer with detailed information on their existing database system, […]

Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 Jun 2017

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse platforms to Amazon Redshift. Wait, what if you don’t need to move all those terabytes of data, and just want to settle for the data generated in the past couple of years? Starting from the version 1.0.603, SCT allows filtering the data before uploading it to Redshift. In addition, the latest SCT […]

Oracle to PostgreSQL database migration and unification project
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 Jun 2017

One of the leading independent software vendors in educational domain needed to expand their original Oracle database system. They wanted to add a new PostgreSQL database running on AWS RDS to their original system and upgrade the connected Java application to support both database platforms. We came up with a proof of concept and converted one of the largest customer’s database schemas to PostgreSQL, demonstrating how the upgraded system might work. To do so, we updated the application by adding […]