Top AWS DMS and SCT blog posts
08 Feb 2018

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 AWS Schema Conversion Tool, which […]

Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
Operational Data Management Helps Multimedia Content Provider Build a New System on AWS
25 Jan 2018

One of the world’s largest multimedia content providers was looking for a way to increase the level of user satisfaction by improving the performance of their enormously huge database system. They wanted to leverage operational best practices to increase resiliency/uptime, performance, and scalability at the lowest possible cost. DB Best provided the customer with the day-to-day operational data management services both on-premises and in the cloud, as well as configured the new architecture for their cloud-based system. Discover the benefits […]

AWS Snowball Edge
Using AWS Snowball Edge to transfer multiple terabytes of data into the Amazon cloud
10 Jan 2018

Managing data and applications anywhere, we often face the issues related to the migration of huge amounts of data for our customers. So, as the Amazon partner, we received the brand new AWS Snowball Edge for testing purposes and tried to migrate our Oracle Database to Amazon Aurora PostgreSQL. Check out our blog post to learn more about our experience with AWS Snowball Edge.

AWS Glue ETL service
Loading Amazon Redshift Data Utilizing AWS Glue ETL service
27 Dec 2017

In this article, we’ll look into how regular data loading jobs can be moved to Redshift using AWS Glue ETL service on a regular basis. Our specific focus is on migrating stored procedure code of Teradata ETL to AWS Glue scripts.

Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)
19 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 – Columnstore Indexes If you missed the session, or would like to watch the recorded session, the recording will be available soon. Don’t miss the next webinar on January 9th: Viewing Query Plans!   The registration link will be posted here when available, In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not […]

Amazon Redshift Performance Tuning Tips
Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 Dec 2017

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution […]

Webinar 2.8 Followup (Episode 11 – Compression)
12 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.8 – Data Compression     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 19th: Columnstore Index Storage!   You can register here,   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this […]

Webinar 2.7 Followup (Episode 10 – Partitioning)
05 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.7 – Partitioning     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 12th: Data Compression!   You can register here.   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, […]

Webinar 2.6 Followup (Episode 9 – Fragmentation)
28 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.6 – Fragmentation If you missed the session, or would like to watch the recorded session, the recording is available here. Don’t miss the next webinar on December 5th: Partitioning!  Registration is available here. In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics […]

Webinar 2.5 Followup (Episode 8 – Nonclustered Indexes)
21 Nov 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.5 — Nonclustered Indexes Because this week is a holiday week in the US, there is NO HOMEWORK! If you missed the session, or would like to watch the recorded session, the recording is available through this link. Don’t miss the next webinar on November 28th: Fragmentation! You can register here: https://www.eventbrite.com/e/webinar-kalen-delaneys-sql-server-internals-webinars-episode-9-tickets-39714618493 In addition, I am publishing a list of the upcoming topics. Please be […]