AWS Database Blog

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.

When an Amazon Neptune workload needs resilience beyond a single cluster, this post presents a decision framework that maps availability targets to Neptune architectural patterns, from Multi-AZ and Global Database to write-ahead logs and caching, based on your RTO, RPO, and budget.

Migrating SQL Server Full-Text Search to Babelfish for Amazon Aurora PostgreSQL is one of the trickier parts of a migration. This post presents a six-checkpoint decision tree to assess whether your Full-Text Search workload can move to Babelfish, what migrates directly, what needs a custom function, and what requires an alternative approach.

Amagi built a Global Metadata Store on Amazon Neptune to model billions of interconnected media metadata relationships. Learn how their RDF knowledge graph, paired with Amazon OpenSearch Service and a custom blank-node synchronization layer, delivers deep semantic queries and sub-500ms transactional reads across 2,500+ channels and 150+ countries.