Oracle Forms SQL statements
How to run SQL statements after migrating from Oracle Forms to web applications
09 Aug 2019

At DB Best, we’ve helped several customers move away from Oracle Forms to a modern web-based solution. To accomplish this, developed a totally new Oracle Forms Converter. This tool allows for automating the migration of your Oracle Forms to web single page applications.  In this blog post, I’ll talk about making SQL statements from Oracle Forms compatible with your new application. The problem Oracle Forms run different queries and execute SQL statements directly at the connected Oracle Database. These SQL statements are […]

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.

ongoing development
Why you should never stop application development?
02 Aug 2019

The application development lifecycle has 6 proven stages that lead to the application’s release. In reality, the development process never ends with the initial release. There are always brighter ideas, new features, and enhancements that take you back into the development phase. Later, these ideas become the 2.0 version of your application. That’s what we call the “ongoing development process”.

cleaning-up-sql-server
Cleaning up a disorganized SQL Server for informed business decisions
26 Jul 2019

For quite a period of time, our customer was using a SQL Server database that at the long last became disorganized and fairly difficult to arrange. The difficulties with finding and retrieving the right data negatively influenced their performance. In addition, their server was storing duplicating views and tables that utilized space. The problem Our customer considered hiring several data analysts to reinforce their team. However, extra people in the team couldn’t address the challenge for they weren’t aware of […]

naming convention
Defining a naming convention in Oracle to SQL Server migrations
17 Jul 2019

When migrating Oracle databases to Microsoft SQL Server, you need to define a naming convention for the conversion of packaged procedures and functions. This step is as important as setting the schema mapping and data type mapping. This is an architecture-level decision that you should make at the very beginning of your migration project. Read this blog post to discover the importance of this decision and the possible issues it may cause.

DBBest post about misleading ideas in SW development
Top 10 misleading ideas that don’t work in application development
16 Jul 2019

The DB Best team has been building applications for more than 10 years now. The software development path that we follow and lead our clients through is very exciting. With every new project and task, we become wiser meeting new obstacles and handling them successfully.

So, we’d like to share some key misleading ideas that slowed down both — our teams and those of our clients. Ideas that slowed the development process and delayed us from handling the additional obstacles instead of moving further and faster.

Power BI Premium limit
Reaching the limit with Power BI Premium resources
10 Jul 2019

One of our enterprise-level customers reached the Power BI capacity limit on dedicated cloud computing and storage resources. They already owned the Power BI Premium licensing package and didn’t want to spend more money to buy additional resources.
Reaching the resource capacity limit in Power BI may lead to serious consequences. Data models using this service will fail when refreshing through the gateway. The business will not get new data, causing all teams to fall behind on analysis of information.
See how you can address this issue.

Upgrade application 2019
Upgrade your mobile applications to meet the marketplace requirements in 2019
09 Jul 2019

Apple and Google set new rules for mobile applications on the App Store and Google Play annually. Even if you are not a developer, as a business person whose business is strongly associated with an application or a mobile platform, you should review them.
Read the blog post to learn more about the restrictions and updates we will face within the app market in 2019.

convert SQL Server Standard edition to Developer Edition
How to convert a development server running SQL Server Standard or Enterprise edition to Developer edition
03 Jul 2019

I recently had a client using SQL Server 2012 Standard Edition on three of their development servers. However, SQL Server 2012 has a developer edition that is specifically designed for development servers. More importantly, our client has free SQL Server 2012 Developer edition licenses as part of the paid SQL Server Standard Editon purchase.
Our customer decided to convert their Standard Edition to the Developer Edition so they could save big bucks. However, the conversion process can be a bit tricky. In this blog post, we will show how you can easily convert SQL Server Standard Edition to the Developer Edition.

Oracle Forms Converter
Introducing the all-new Oracle Forms Converter
02 Jul 2019

A public sector organization from the US faced a problem with an outdated Oracle Forms-based solution. They had thousands of users but couldn’t keep the existing system running at an optimized quality and usability level. Their first option was to create a completely new web-based application to make their Oracle Forms run on the web. However, we at DB Best came up with a second, more cost-effective option that also saved time. We offered to transfer their Oracle Forms to an up-to-date JavaScript code as single-page applications (SPA) running on the web.
Find the details of the DB Best solution in our blog post.