Category: Technical How-to

In Part 1 of this series, we discussed how the IDENTITY column is used in different relational database management systems. In this post, we focus on how AWS Database Migration Service (AWS DMS) handles tables with IDENTITY column. For the source database, AWS DMS captures the IDENTITY column as a regular column. For the target […]

In relational database management systems, an IDENTITY column is a column in a table that is made up of values generated automatically by the database at the time of data insertion. Although different systems handle the implementation of IDENTITY columns differently, they share some common characteristics. In most cases, the value of the IDENTITY column […]

Regular backups are a key component of designing business-critical applications to be resilient in the event of any failure situation. They provide many benefits, the most important being data protection, more efficient recovery of data in the event of disruptions, compliance with organization and legal requirements, and simplified maintenance. Point-in-time recovery (PITR) for DynamoDB provides […]

While managing databases at scale in AWS, there are certain scenarios where you may need to maintain an Amazon Aurora cluster in a single or multiple AWS accounts. These scenarios include but are not limited to mergers and acquisitions, consolidating all accounts to use only a single account, or compliance to maintain production and development […]

Amazon DynamoDB supports transactions to give atomicity, consistency, isolation, and durability (ACID), helping you maintain data consistency in your workloads. A database transaction is a sequence of multiple operations that are performed on one or more tables. These sequences of multiple operations represent a unit of work that is committed to the tables or rolled […]

Many global corporations are managing multiple supply chains, and they depend on those operations to not only deliver goods on time but to respond to divergent customer and supplier needs. According to a McKinsey study, it’s estimated that significant disruptions to production now occur every 3.7 years on average, adding new urgency to supply chain […]

In Amazon Relational Database Service (Amazon RDS), an RDS event indicates a change in the environment. These events are delivered in real-time to Amazon CloudWatch and Amazon EventBridge. RDS events are notifications that are triggered by specific database events in Amazon RDS. These events can include automated backups, security updates, maintenance windows, and other changes […]

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

This post is a continuation of Federated query support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL – Part 1. To recap, in 2003, the SQL standard added a new specification called SQL/MED (SQL Management of External Data). In 2011, PostgreSQL 9.1 was released with read-only support of this standard, and PostgreSQL 9.3 added […]

SAP SQL Anywhere (also known as Sybase SQL Anywhere) is a database which is widely used in Information Technology and Services industry. Migration from SAP SQL Anywhere to Amazon Relational Database Service (RDS) for SQL Server or Microsoft SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) is challenging because as of writing this post, […]