Converting Oracle system functions to PostgreSQL with AWS SCT extension pack
16 Nov 2020

Migrating Oracle databases to PostgreSQL on AWS, you often face challenges with converting system functions. Oracle has a rich set of built-in functions, and PostgreSQL doesn’t provide users with all of those. To support and simplify Oracle to PostgreSQL on AWS migrations, AWS Schema Conversion Tool provides users with an extension pack. After applying it to your Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL database, you may use the functions, which emulate the behavior of Oracle’s system functions. You […]

Top customers’ stories on AWS
03 Aug 2020

Last updated in August 2020 The goal of DB Best blog is to deliver technical content on various completed projects and researches. Publishing over 100 blog posts per year, we pay great attention to the projects, related to the cloud data platforms in general, and Amazon Web Services (AWS) in particular. Some of the AWS customers’ stories attract more attention than others, so, that’s why we decided to collect them in one place. We consider these articles must-read and super […]

Top AWS DMS and SCT blog posts
03 Aug 2020

Last updated in August 2020 Sharing our technical experience with the readers, we’ve reached a pretty impressive audience on our blog. So, it was pretty easy to distinguish the most popular AWS Database Migration Service (AWS DMS) Support stories. Let’s jump right in and review the most valuable and really important DB Best blog posts on AWS DMS and AWS Schema Conversion Tool (AWS SCT). We’ve got an impressive series of blog posts, where we talk about the features of […]

Collecting business-critical transaction throughput for analyzing using Power BI
14 Jan 2020

In my blog post Using Power BI to analyze Windows Perfmon data for SQL Server, I introduced a concept that I call “business-critical transactions” (BCT) to understand the overall throughput of your SQL Server applications. When I worked on the SQL Server team, the SQL Performance Engineering team used a set of customer applications with server-side replay scripts that would get executed before development teams checked in their code. If a development team’s build showed significant regression in performance, they could […]

automating database migration
Automating database migration projects with DB Best Migration Platform
06 Nov 2019

DB Best released a multi-purpose Migration Platform, introducing full automation for all steps of a database upgrade or migration project. Read our blog post and watch the related video to discover how DB Best Migration Platform can automate your database migration and upgrade initiatives.

cost-effective architecture Azure
Best practices, key considerations, and epic fails of cloud adoption for an enterprise-level customer
20 Aug 2019

Subject/Title: Best practices, key considerations, and epic fails of cloud adoption for an enterprise-level customer Alternative option: Building a cost-effective architecture in the Azure cloud Type of Content: Starting a series of blog posts that cover our experience with the cloud technologies and cloud migrations. We need these blog posts to support cloud lunch-and-learn events. Target audience: IT executives and professionals Summary of Content: Talk about our positive experience as well as the fails and mistakes that we had during […]

migrate Apache Cassandra to Amazon DynamoDB
Using AWS Schema Conversion Tool to migrate Apache Cassandra to Amazon DynamoDB
19 Feb 2019

Looking for greater flexibility, speed, and scale for your Apache Cassandra solutions? It’s time to consider Amazon’s DynamoDB as a great alternative. We would like to share our hands-on experience and insights for those looking to migrate Apache Cassandra to Amazon DynamoDB using the new data extraction agents that AWS recently released with the Schema Conversion Tool. This migration approach involves adding an additional datacenter to an existing Cassandra cluster. This datacenter clones all data from the original cluster, and […]

migrate oracle to amazon ec2
Save on Licensing Costs and Migrate Oracle to Amazon EC2
08 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. The Situation […]

Top 5 reasons for migrating to Azure SQL Database Managed Instances now!
02 Oct 2018

Microsoft is doubling down on Azure SQL Database Managed Instances (DMI) this year. There are some amazing Microsoft offers to provide a Platform-as-a-Service for running SQL Server on Azure. More importantly, there is a much higher degree of capability with DMI than what is available with Azure SQL Database DTU and vCore service levels. In this blog post, you will discover the most important reasons for migrating to Azure SQL Database Managed Instances. Also, you will learn how DB Best experts […]

Windows IIS and SQL Server on AWS
Deploying Windows IIS and SQL Server on AWS with CloudFormation
16 Aug 2018

In order to modernize their existing applications, databases, and infrastructure, the Office of the President of the University of California (UCOP), approached DB Best with a desire to not only create their ideal database environment but to cut costs along the way. Throughout our intensive discovery stage, we determined that we could help our client cut costs by migrating their Windows Internet Information Services (IIS)  and SQL Server to the Amazon Cloud (AWS). Over the course of our partnership, DB […]