AWS Database Blog

Category: Technical How-to

Migrate SQL Server user databases from Amazon EC2 to Amazon RDS Custom using Amazon EBS snapshots

In this post, we present a practical approach to one of the most significant challenges organizations face when adopting Amazon RDS Custom for SQL Server: migrating large datasets from SQL Server on Amazon EC2 to Amazon RDS Custom for SQL Server efficiently and cost-effectively. By using SQL Server’s native detach and attach method combined with EBS snapshots, you can migrate your databases without requiring Amazon S3 or AWS DMS.

Integrate your Spring Boot application with Amazon ElastiCache

In this post, we explore the basics of integrating a Spring Boot application with ElastiCache to enable caching. Amazon ElastiCache is a fully managed, Valkey-, Memcached-, and Redis OSS-compatible service that delivers real-time, cost-optimized performance for modern applications with 99.99% SLA availability. ElastiCache speeds up application performance, scaling to millions of operations per second with microsecond response time.

Using generative AI and Amazon Bedrock to generate SPARQL queries to discover protein functional information with UniProtKB and Amazon Neptune

In this post, we demonstrate how to use generative AI and Amazon Bedrock to transform natural language questions into graph queries to run against a knowledge graph. We explore the generation of queries written in the SPARQL query language, a well-known language for querying a graph whose data is represented as Resource Description Framework (RDF).

Working with OEM Agent software for Amazon RDS for Oracle

Amazon RDS for Oracle supports specific versions of the OEM Agent. Amazon recently released OEM Management Agent version 13.5.0.0.v2 for Amazon RDS for Oracle databases. OEM Agent version 13.5.0.0.v2 requires Oracle Management Server (OMS) version 13.5.0.23 at the minimum. In this post we explore critical scenarios affecting OEM Agents on Amazon RDS for Oracle Database instances and outline essential considerations for users.

Build low-latency, resilient applications with Amazon MemoryDB Multi-Region

On December 1, 2024, we announced the general availability of Amazon MemoryDB Multi-Region, a fully managed, active-active, multi-Region database that you can use to build applications with up to 99.999% availability, microsecond read, and single-digit millisecond write latencies across multiple Regions. In this post, we cover the benefits of MemoryDB Multi-Region, how it works, its disaster recovery capabilities, the consistency and conflict resolution mechanisms, and how to monitor replication lag across Regions.

Improve PostgreSQL performance using the pgstattuple extension

In this post, we explore the pgstattuple extension in depth; what insights it offers, how to use it to diagnose issues in Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL, and best practices for harnessing its capabilities.

Using StatsD for monitoring Oracle databases running on Amazon RDS or Amazon EC2

Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that can result in data loss or downtime. Having custom dashboards and alarm-based monitoring for the database can help in analyzing historical metrics patterns and improve database availability by alerting users of any abnormal threshold breaches. In this post, we show you how to set up monitoring for your Oracle database using StatsD.

Up and running with Apache OFBiz and Amazon Aurora DSQL

In this post, we show you a worked example of taking an existing application that works on PostgreSQL databases and adapting it to work with an Aurora DSQL database. In addition to adapting for the previously mentioned aspects, we also address some data type incompatibilities and work around some limits that currently exist in Aurora DSQL.

Transition a pivot query that includes dynamic columns from SQL Server to PostgreSQL

When assisting customers with migrating their workloads from SQL Server to PostgreSQL, we often encounter a scenario where the PIVOT function is used extensively for generating dynamic reports. In this post, we show you how to use the crosstab function, provided by PostgreSQL’s tablefunc extension, to implement functionality similar to SQL Server’s PIVOT function, offering greater flexibility.