AWS Database Blog

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.

Migrating SQL Server Integration Services (SSIS) packages is one of the more complex parts of moving from SQL Server to Amazon Aurora PostgreSQL. In Part 1 of this two-part series, learn how to filter, categorize, and simplify your SSIS portfolio using native PostgreSQL features, pg_cron, and the aws_s3 and aws_lambda extensions.

Configure AWS DMS change data capture (CDC) from a self-managed SQL Server source without granting sysadmin to the endpoint login. This least-privilege pattern uses certificate-signed wrapper procedures, granular permissions, and AWS Secrets Manager to meet separation-of-duties requirements while preserving full CDC functionality.