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 […]

Oracle to PostgreSQL migration tool
Comparing Ora2Pg with АWS SCT for Oracle to PostgreSQL migration
18 May 2020 , Bill Ramos

AWS Schema Conversion Tool (SCT) and Ora2PG allow for automating database migration from Oracle to PostgreSQL. Which tool would you prefer to use in real migration project for enterprise accounts? Read this blog post to find the answer.

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 […]

analyze Windows Perfmon
Using Power BI to analyze Windows Perfmon data for SQL Server
13 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. You can find the source code, Power BI reports, and other related files on my GitHub site at https://github.com/db-best-technologies/power-bi-for-sql-dbas. Here is a summary of what’s coming up in the series. It is subject to change based on feedback and reader demand: Capturing performance […]

optimize SQL Server performance on AWS EC2
Capturing performance counters to optimize Microsoft SQL Server performance on AWS EC2 instances
04 Jan 2020

Over the last few months of benchmarking SQL Server performance on AWS, I discovered a way to optimize SQL Server performance running on EC2 instances by paying close attention to several key Windows performance counters. This blog post is the first in my new series called Power BI for the SQL Server DBA. I’m going to show how you can easily capture performance counters to optimize SQL Server performance and cost on AWS EC2 instances. I’m going to start with […]

SQL Server 2017 AWS EC2
Are you getting the best value out of AWS EC2 running with SQL Server 2017?
25 Oct 2019

Last year, we published the blog post on Validating AWS EC2 SQL Server Deployments Using Benchmark Tools. Since then, AWS released enhancements like Optimizing CPU Option that allow you to choose a larger EC2 instance for your SQL Server 2017 instances for greater Memory and IOPS / vCPU to keep your licensed vCPU count down.
Read this bog post to discover how benchmarking your SQL Server workloads on AWS in a pre-production environment can help you pick the best candidate EC2 instance with an optimized storage configuration based on real data.

lost-and-found-platform
Developing a worldwide lost and found platform
06 Jun 2019

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how DB Best turned this idea into reality.

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 […]