We’re happy to announce the latest release of Database Compare Suite 4.12. This new version brings several important improvements and bug fixes, including:
Continue reading to learn more about the ultimate DBA tool and discover all of the major improvements implemented in this latest application release. Read the rest of this entry »
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 useful.
Please take a look through our list of the most read customers’ stories on AWS.
Top 3 AWS customers’ stories
We’ve had an amazing experience, migrating on-premises Oracle database to the AWS cloud for a major data processing company. We delivered a cost and time-effective turnkey solution, adding automated monitoring and reporting capabilities to their existing solution.
Another brilliant example of reducing customer’s operational costs by moving their Oracle on-premises database into the AWS cloud. We created highly available and easily scalable database system, providing the customer with a set of best practices on operating the new cloud environment.
Our customer wanted to support additional database platform to their original Oracle database system. They wanted to expand their on-premises system with a new PostgreSQL database running at AWS RDS. We came up with a magnificent solution to unify the application’s SQL code. After unification, the application was running correctly against both databases. You can check the details of this sophisticated project in the following blog post.
Check how we implemented a variety of Amazon Web Services to build a set of video streaming applications for one of our regular customers. Highlighting the unlimited power of web services, we will show you how to keep costs under control even under the extremely increasing workloads.
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 is the must-use utility for moving workloads into the Amazon cloud. In addition to that, we talk about popular conversion issues, helping you overcome the action items, which occur during the migration process.
Let’s start with the Amazon Redshift Performance tuning tips. We’ve worked on this blog post for several months to tell you the real story of Redshift optimization project and describe the best practices we’ve learned.
Another massive experience was related to the AWS Snowball Edge appliance. We had a unique chance to use this cool device, which combines 80 TB of built-in storage and compute power to migrate our on-premises Oracle database to AWS Redshift.
Summing up the top 3 technology AWS blog posts, comes our research on taking advantage of AWS Glue ETL service to load the data into Amazon Redshift after migrating the Teradata data warehouse into the Amazon cloud.
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 of the outsource Operational Data Management (ODM) solution from the following video.
One of the main concerns during large-scale database migrations to the cloud is how long will the data transfer last. When you need to move multiple terabytes of data, the migration process may last for weeks or even months. In addition, the bandwidth of your network connection becomes a limiting factor, and some security concerns may appear. So, the whole migration project becomes unsustainable, and many customers with heavy-weight databases had to abandon their cloud migration initiatives. Amazon came up with a physical solution called AWS Snowball Edge, which allows for fast and secure data transfer of up to 80 TB of data in a matter of days.
We at DB Best had a great opportunity to test the latest AWS Snowball Edge device in our data-center. Being half the size of the original AWS Snowball, the latest version of the appliance can store up to 83 TB of data. This allows for speeding up large-scale data transfers, even taking into account the shipping time of the device.
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. Watch the following video to learn more about our experience with AWS Snowball Edge.
Your CIO made a strategic decision to move to AWS and you are wondering how to move your Enterprise Data Warehouse (EDW) on Teradata: should you opt for using Teradata Software Tears on AWS Marketplace with EC2 instances, or consider migrating to Amazon Redshift? The latter option looks interesting, but there’s one big issue: Redshift doesn’t support stored procedures. You’ve got a plenty of procedural code as part of your Extract-Transform-Load (ETL) processes, but it is not clear how to move it to Redshift. 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.
For the sake of this exercise we chose a following typical scenario from our Teradata ETL:
Source data: the file is dropped onto FTP server;
Transformations: filter, join, calculation, aggregation data from datasets;
Target: load resulting dataset inserted into Redshift table.
We’ll try to build the same scenario on AWS Glue ETL service to see whether it can be a workable solution or not.
Continue reading to see how we approached the loading Amazon Redshift data utilizing AWS Glue and converted the source ETL scripts to the new format. Read the rest of this entry »
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 complete at this point, but it does show the planned topics for the next several months. I will be updating it periodically
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 times when users start noticing performance issues.
Amazon introduced a feature called Redshift Optimization for the AWS Schema Conversion Tool (SCT) with the November 17, 2016 release. You can now use the Schema Conversion Tool the optimization of existing Amazon Redshift deployments! This dramatically reduces the manual effort of addressing performance issues with your Redshift deployments.
Here’s why you should consider taking advantage of the Redshift Optimization option in the AWS Schema Conversion Tool.
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 point, but it does show the planned topics for the next several months. I will be updating it periodically
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, but it does show the planned topics for the next several months. I will be updating it periodically
