Category: Database

Many customers have Oracle multi-tenant databases in their on-premises environments, and may be looking to use Amazon Relational Database Service (Amazon RDS) for Oracle features while using multi-tenant databases. As of August 2022, Amazon RDS for Oracle supports a subset of multi-tenant architecture called single-tenant architecture. A multi-tenant architecture enables an Oracle database to function […]

Amazon QLDB made Earnin’s mobile application more reliable, secure and fast. It also made our backend simpler and allowed our data scientists to be more efficient.

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports database activity streams to provide a near-real-time stream of database activities in your relational database. To protect your database from internal and external threats, and to meet compliance and regulatory requirements, you can easily integrate the database activity stream with third-party database activity monitoring […]

An Oracle to Amazon Aurora PostgreSQL-Compatible Edition or to Amazon Relational Database Service (Amazon RDS) for PostgreSQL migration is a multi-stage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. For more information about the database migration process, refer to the following posts: Database Migration—What Do You Need […]

Linked servers allow Microsoft SQL Server to run SQL Server statements on other instances of database servers. They are a good solution when you need to implement database sharding without needing to create custom application code or directly load from remote data sources. In this post, we focus on creating linked server access to Amazon […]

In this post we focus on data analysis as part of the modern data strategy. I cover how to generate insights from healthcare FHIR (Fast Healthcare Interoperability Resources) data with Amazon Neptune, a fast, reliable, fully managed graph database service. Using a graph database for this use case allows you to model and navigate complex […]

Today, you can achieve cross-Region disaster recovery (DR) using the Amazon RDS for SQL Server Cross Region Read Replica feature, but it’s only available for workloads running on SQL Server Enterprise edition (EE). You can also use the cross-Region automated backups feature to develop your DR strategy, but recovery time objective (RTO) and recovery point […]

In this post, we discuss AWS Database Migration Service (AWS DMS) and how you can use Amazon CloudWatch and logs to monitor the performance and health of a replication task. Additionally, we discuss how to set up CloudWatch Alarms for an AWS DMS task as well as instance related metrics that we configure to receive […]

Amazon RDS Custom for SQL Server is a managed database service for applications that require customization of the underlying operating system and database environment. Amazon RDS Custom allows you to access and customize your database server host and operating system, for example, by applying special patches and changing the database software settings to support third-party […]

In this post, we explore how text collations work in PostgreSQL, the effect on PostgreSQL when the collation changes, and how to detect these changes. We also review how Amazon Relational Database Service (Amazon RDS) and Amazon Aurora can help you manage collations using an independent default collation library, and future work in PostgreSQL on […]