migrate oracle to amazon ec2
Save on Licensing Costs and Migrate Oracle to Amazon EC2
04 Jan 2019

How can a world-leading multimedia content producer migrate Oracle to Amazon EC2 with minimal downtime while also reducing licensing costs? In this blog post, we discuss how we saved our customer 28% in Oracle licensing costs, implemented a reliable HA/DR solution, and migrated their immense environment to the AWS cloud with near-zero downtime using Oracle Data Guard.

To better understand the client’s existing infrastructure, requirements, and potential limitations, let’s explore the customer’s environment prior to our successful migration.

Data comparison
Comparing data in your databases using Database Compare Suite
09 Jul 2019

We start a series of video blog posts that cover the key features of Database Compare Suite. This is an ultimate solution for database developers, administrators, quality assurance, and DevOps engineers to simplify their daily routine. Database Compare Suite automates schema and data manipulations in homogeneous or heterogeneous database environments. This tool allows for comparing and synchronizing database objects. Also, you can compare, synchronize, and migrate data in databases with equal or close-to-equal database schemas. You can execute the data […]

Oracle Forms SQL statements
How to run SQL statements after migrating from Oracle Forms to web applications
08 Jul 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 […]

naming convention
Defining a naming convention in Oracle to SQL Server migrations
04 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. Now, we will talk about the importance of this decision and the possible issues it may cause. The problem By default, SQL Server Migrating Assistant (SSMA) […]

Power BI report update failure
Troubleshooting a Power BI report update failure
04 Jul 2019

Working with one of our customers, I discovered that the reports include outdated data. I started digging deep into this issue and discovered several reports that were not refreshed. The problem First of all, I figured out that the Power BI administrators don’t know when an automatic refresh fails using the gateway. This leads to a situation when the analyst provides a report based on old data without knowing the report was not updated. So, the developers and administrators are […]

Power BI Premium limit
Reaching the limit with Power BI Premium resources
02 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. What to do when reaching your Power BI Premium limit 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 […]

Docker
DevOps and Test Automation: Docker saves the day!
27 Jun 2019

Subject/Title: DevOps and Test Automation: Docker saves the day! Type of Content: A blog post that covers the DB Best experience with Docker (based on the Cassandra to DynamoDB migration project). Target audience: Developers (candidates to join DB Best), IT professionals, potential customers. Summary of Content: Deep technical dive into our projects. Introduction Migrating from Cassandra to DynamoDB, we needed to run multiple tests. We faced a problem with setting up the test environment. It took a lot of time […]

The DD Best blog post cover
Top 10 misleading ideas that don’t work in application development
27 Jun 2019

The DB Best team has been building applications for more than 10 years now. These solutions include education, healthcare, social, entertainment, fitness, leisure, and many other sectors. And, a lot of them grew into established businesses and enterprises that started with a bright idea. 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. What we have learned at […]

convert SQL Server Standard edition to Developer Edition
How to convert a development server running SQL Server Standard or Enterprise edition to Developer edition
24 Jun 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. The problem Our customer decided to convert their Standard Edition to the Developer Edition so they could save big bucks. However, the conversion process can be […]

remove the Management Data Warehouse from SQL Server
How to remove the Management Data Warehouse from SQL Server running on a production instance
24 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. We replaced the MDW with the Open Query Store project, a community supported […]