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.

Invoke-Sqlcmd variable parameter
Using PowerShell Invoke-Sqlcmd with Variable parameter
24 Feb 2020

I recently needed to use PowerShell to call a T-SQL script using Invoke-Sqlcmd with the -Variable parameter. In my case, I wanted to specify the locations for backup files and where to restore the data and log files. Rather than add the conditions into the SQL script, I wanted to make the SQL script as generic as possible, and use SQLCMD variables for the different scenarios. In this blog, I’ll show how to use the array sub-expression operator and “splatting” […]

ML in construction blog post cover image
Eliminate safety breaches in construction with ML algorithms
11 Feb 2020

In this blog post, we describe how we developed a solution to prevent the most common safety breaches in construction. The solution combines machine learning algorithms and computer vision technologies to detect workers not wearing helmets analyzing video materials. Our algorithms reached 98% accuracy, and we’re proud that the solution actively used by our customers.

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

anomaly detection
How we improved customer analytics with machine learning algorithms
08 Jan 2020

Using multiple data sources often causes data to be out of sync. This results in data mess or conflicts and significantly affects your analytic reports. To make informed decisions, you need a proven automated solution that allows for discovering data anomalies. Especially when you operate with tons of data. The DB Best team utilized machine learning to build the anomaly detection tool for one of our customers. Our sophisticated solution improves the quality of data and helps take deliberate business decisions. In this blog post, we will show you how to make use of time series-based algorithms and the sequence of the steps for training a neural network.

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