AWS Database Blog

Category: Advanced (300)

Patterns for AWS IoT time series data ingestion with Amazon Timestream

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. Large-scale internet of things (IoT) applications generate data at fast rates, and many IoT implementations require data to be stored sequentially, based on date-time values generated either […]

Choose View.

Configuring an audit log to capture database activities for Amazon RDS for MySQL and Amazon Aurora with MySQL compatibility

September 2022: This post was reviewed for accuracy. Organizations improve security and tracing postures by going through database audits to check that they’re following and provisioning well-architected frameworks. Security teams and database administrators often perform in-depth analysis of access and modification patterns against data or meta-data in their databases. During auditing, you may raise the […]

The following diagram is a Neptune Workbench visualization of the relationship between a document, a corporate acquisition event, and the organizations (with their roles) involved in that event.

Building a knowledge graph in Amazon Neptune using Amazon Comprehend Events

On 28-Oct-22, the AWS CloudFormation template and Jupyter notebook linked in this post were updated to 1/ add openCypher queries along with the existing Gremlin and SPARQL queries, 2/ updated to use Sagemaker newer Amazon Linux 2 instances, 3/ fixed a bug in the RDF generation code that improperly labeled a property as an RDF […]

The following diagram shows the architecture of the launched graph-app-kit stack for Neptune.

Enabling low code graph data apps with Amazon Neptune and Graphistry

One of the common challenges to unlocking the value of graph databases is building easy-to-use, customer-facing data tools that expose graph-powered insights in impactful and visual ways. Data engineers need to inspect data quality, data scientists need to perform discovery and inspect models, analysts need to investigate connections, and managers need insight into what’s going […]

The following diagram illustrates this architecture.

Cross-account replication with Amazon DynamoDB

February, 2026: Amazon DynamoDB global tables now support replication across AWS accounts. Learn more. July 2024, this post has been reviewed for accuracy. Hundreds of thousands of customers use Amazon DynamoDB for mission-critical workloads. In some situations, you may want to migrate your DynamoDB tables into a different AWS account, for example, in the eventuality […]

The following diagram illustrates this architecture.

Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database

December, 2022: Amazon Relational Database Service (Amazon RDS) now supports Amazon RDS Blue/Green Deployments to help you with safer, simpler, and faster updates to your Amazon Aurora and Amazon RDS databases. Blue/Green Deployments create a fully managed staging environment that allows you to deploy and test production changes, keeping your current production database safe. Learn […]

Federated query support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL – Part 1

PostgreSQL is one of the most widely used database engines and is supported by a very large and active community. It’s a viable open-source option to use compared to many commercial databases, which require heavy license costs. Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition are AWS managed offerings that […]

Migrating SQL Server to Amazon RDS using native backup and restore

September 2025: This post was reviewed for accuracy. Running Microsoft SQL Server on Amazon Relational Database Service (Amazon RDS) automates time-consuming administration tasks such as installation, disk provisioning and management, patching, minor and major version upgrades, and backup and recovery of your SQL Server databases. Amazon RDS also offers high availability using a Multi-AZ solution, […]

Using Database Mail on Amazon RDS for SQL Server

We’re happy to announce that Amazon RDS for SQL Server now fully supports SQL Server Database Mail. Before this release, you needed to use a variety of work-arounds to enable Database Mail, such as using linked servers. With the release of Database Mail for SQL Server, you can enable Database Mail seamlessly by using database parameter groups. Database Mail is one of the heavily used features in Microsoft SQL Server. Database Mail enables you to send messages from the SQL Server to users by using a Simple Mail Transfer Protocol (SMTP) server. In this post, you learn how to configure Database Mail and send emails from an RDS for SQL Server DB instance via Amazon Simple Email Service (Amazon SES).