Category: Advanced (300)

If you have complex data types such as maps and lists in your Amazon DynamoDB data, refer to Part 2 of this series. Bulk updates to a database can be disruptive and potentially cause downtime, performance impacts to your business processes, or overprovisioning of compute and storage resources. When performing bulk updates, you want to […]

June 2023: Amazon DynamoDB can now import Amazon S3 data into a new table. DynamoDB import from S3 helps you to bulk import terabytes of data from Amazon S3 into a new DynamoDB table with no code or servers required. November 2022: This post was reviewed and updated for accuracy. This post reviews what solutions […]

This blog post was last reviewed and updated July, 2024. Amazon Relational Database Service (RDS) enables you to use AWS Identity and Access Management (IAM) to manage database access for Amazon RDS for PostgreSQL database instances and Amazon Aurora PostgreSQL clusters. Database administrators can associate database users with IAM users and roles. With IAM database authentication, you don’t need to use a […]

September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. May 2025: This post was reviewed and updated for accuracy. As organizations grow their database footprint across multiple AWS accounts, maintaining visibility into database operations becomes increasingly challenging. This post demonstrates how to implement a centralized logging solution using Amazon […]

August 30, 2023: Amazon Kinesis Data Analytics has been renamed to Amazon Managed Service for Apache Flink. Read the announcement in the AWS News Blog and learn more. Many graph applications can benefit from the ability to capture changes to items stored in an Amazon Neptune database, at the point in time when such changes […]

This blog post was last reviewed or updated May, 2023. The updated version shown below is based on working backwards from a customer need to use RDS Performance Insights metrics in their APM tool for database observability. Amazon RDS Performance Insights is a feature that monitors Amazon Relational Database Service (Amazon RDS) database instances so […]

Enterprise customers who are currently running on-premises, mission-critical applications on commercial databases are looking for cost-efficient, managed database service offerings. Amazon Relational Database Service (Amazon RDS) is one of the target platforms for the relational database workload migration. RDS provides resizable capacity and manages time-consuming and undifferentiated heavy lifting administration tasks. For large-scale database migrations, […]

April 2024: This post was reviewed and updated for accuracy. Gaming leaderboards enable players to gauge their performance against each other. This important social feature increases players’ engagement and encourages competition. Leaderboard data can also inform in-game algorithms that match players against competitors of similar skill levels. In this post, I explore the challenges around […]

If you still have Microsoft SQL Server 2008 and 2008 R2 instances deployed, now is the time to upgrade them. Microsoft end of support (EoS) date for each is almost upon us—July 9, 2019. This means that after that there are no further security updates, which has security and also compliance implications, so don’t wait! Today, I’m excited […]

March 2025: This post was reviewed and updated for accuracy. After migrating or launching your new Amazon Aurora MySQL-Compatible Edition cluster in the AWS Cloud, have you asked yourself one or more of the following questions? What are the next steps? How can I make it run optimally? Is it recommended to modify any existing […]