Category: Technical How-to

Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, covering collation, tokenization, accent-insensitive search, and synonyms.

PostgreSQL out-of-memory (OOM) events and excessive disk spilling are among the most common production incidents on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Learn how PostgreSQL allocates and consumes memory, how to identify memory-intensive queries, and how to diagnose, prevent, and recover from OOM events on both engines.

Learn how to integrate a Spring Boot application with Amazon ElastiCache using Spring Data Valkey for caching. This walkthrough covers adding caching to a serverless cache, plus the advantages of Spring Data Valkey over Spring Data Redis: native AWS IAM authentication, Availability Zone affinity, and OpenTelemetry observability.

Learn how to use binary quantization with reranking (HNSW+BQ) in pgvector to scale vector search to hundreds of millions or billions of vectors on Amazon Aurora PostgreSQL, with practical guidance on index sizing, recall validation, and the scenarios where the approach works best.

Learn how to configure Oracle Materialized Views with Fast Refresh and materialized view logs to enable efficient, incremental AWS DMS change data capture (CDC) replication. This approach eliminates full-reload overhead and achieves near real-time migration of large, multi-table joined views to AWS.

Amazon Aurora DSQL offers time-based observability through Amazon CloudWatch Database Insights. Learn how the DSQL observability model, DASH, Database Insights, PromQL, and the system diagnostics AI skill help you find performance bottlenecks and connect session time directly to cost.

Stream Amazon Aurora DSQL change data capture (CDC) events into Apache Iceberg tables on Amazon S3 with Amazon Data Firehose, then query them using Amazon Athena. This post walks through a two-table design that keeps a full audit trail and a current-state view, plus deployment and a dashboard for exploring the results.

Learn how to use Oracle SQLcl, a lightweight alternative to the full Oracle Client, to create and manage an Oracle Wallet for SSL connections between AWS DMS and Amazon RDS for Oracle. This post walks through installing SQLcl, adding certificates, testing the SSL connection, and configuring the AWS DMS endpoint.

Microsoft SQL Server 2016 reaches its end of extended support on July 14, 2026. If you run it on Amazon RDS for SQL Server with user-defined CLR assemblies, you must replace them before you upgrade, because CLR is not supported on SQL Server 2017 and later. This post shows you how to find your CLR dependencies and compares four replacement strategies.

Standard upgrade paths break active Debezium CDC replication slots on Amazon Aurora PostgreSQL, forcing hours-long re-snapshots. This post shows how to use native PostgreSQL logical replication to bridge a source and target cluster and cut your Debezium connectors over to the new major version with a brief, measured write pause and no re-snapshot.