AWS Database Blog

Node.js teams can run Sequelize ORM on Amazon Aurora DSQL with only a few adaptations. This post builds a hotel reservation application that shows reusable patterns: UUID primary keys, IAM authentication through the Aurora DSQL connector, individual DDL execution, and optimistic concurrency control retry logic.

When you restore an Amazon RDS for PostgreSQL instance from a snapshot, the Amazon EBS volume hydrates lazily, so early queries can run 10x to 15x slower. This post walks through PostgreSQL-native prewarming techniques (pg_prewarm, VACUUM ANALYZE, and full table scans) and new monitoring fields to restore predictable performance faster after restore.

As your Amazon Aurora DSQL workload scales, DPU consumption and storage costs can grow without a fixed instance ceiling. This post shows how to monitor Aurora DSQL usage and cost with the built-in Usage and cost panel, set up Amazon CloudWatch alarms for hourly DPU spend, and deploy the alarms as code with AWS CloudFormation.

Amazon RDS Custom for SQL Server gives you OS-level access, which also exposes internal storage volumes where the W: drive looks like a raw, uninitialized disk. This post explains the C:, D:, and W: drive architecture, how the drives map to Amazon EBS, and the safe disk operations and verification checks that keep you from accidentally destroying your data.

Storing extracted document data in a relational JSON or BLOB column works until you need search and scale. Learn how to recognize when document data has outgrown relational storage, and how to choose between Amazon DocumentDB and Amazon DynamoDB using a progressive, low-risk migration pattern.

Compare Amazon RDS Proxy and PgBouncer for PostgreSQL connection pooling on AWS. This post explains how each pooler handles pooling modes, authentication, failover, and session-state pinning, and gives you a framework to choose between a fully managed service and a self-managed pooler.

After upgrading Amazon RDS for SQL Server to 2017 or later, CLR strict security leaves user-defined CLR assemblies unusable. This post shows how to migrate CLR logic with no native T-SQL equivalent to an AWS Lambda function, invoked from SQL Server 2025 through sp_invoke_external_rest_endpoint behind Amazon API Gateway.

Learn how to build automated email alerts for blocking chains and long-running queries on Amazon RDS for SQL Server. This serverless solution uses AWS Lambda, Amazon CloudWatch, and Amazon SES to detect blocking, identify the root blocker, and send HTML email alerts for approximately $2.57 per month.

MUFG Bank standardized overseas back-office procedures across roughly 30 countries by grounding generative AI in a structured domain model on Amazon Neptune and Amazon Bedrock. Its AI Flowchart application is expected to cut the system-development effort behind each branch-procedure standardization from 11 person-days to 1, a reduction of up to 90%.

Part 2 of migrating SSIS packages to Amazon Aurora PostgreSQL tackles the complex packages. Learn how to replace SSIS control flow, Foreach Loop Containers, and Script Tasks with AWS Step Functions state machines, Map and Parallel states, and Lambda, and schedule them with Amazon EventBridge in place of SQL Server Agent.