AWS Database Blog
Create linked server access to Amazon RDS for MySQL and Amazon RDS for MariaDB
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 […]
Analyze healthcare FHIR data with Amazon Neptune
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 […]
Implement Amazon RDS for SQL Server Standard edition cross-Region disaster recovery using access to transaction log backups feature
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 […]
AWS DMS key troubleshooting metrics and performance enhancers
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 […]
Blockchain and the future of event ticketing
A common frustration among people who buy tickets to concerts, plays, and other events is that each ticket carries multiple fees. The fees often vary in ways that seem hard to comprehend, making the final cost unpredictable. Through the ticket’s lifecycle, multiple intermediaries can add to the cost and collect revenue, with no monetary benefit […]
Monitor Amazon RDS Custom for SQL Server using Amazon CloudWatch
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 […]
Manage collation changes in PostgreSQL on Amazon Aurora and Amazon RDS
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 […]
New for Amazon ElastiCache for Redis 7: Get up to 72% better throughput with enhanced I/O multiplexing
Amazon ElastiCache for Redis is an in-memory data store, delivering real-time, cost-optimized performance for modern applications. It is a fully managed service that scales to millions of operations per second with microsecond response time. Open-source Redis (“Redis OSS”) is one of the most loved NoSQL key-value stores, and is known for its great performance. Our […]
Build a real-time fraud detection solution using Amazon Neptune ML
Each year online businesses lose tens of billions of dollars due to fraud, which can take many forms. For example, fraudsters can obtain stolen credit card details and use them for unauthorized transactions. Therefore, detecting fraud and malicious behavior at the time of a transaction, such as when a user registers a new payment method, […]
Integrate your Spring Boot application with Amazon DocumentDB (with MongoDB compatibility)
Amazon DocumentDB (with MongoDB compatibility) is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads. You can use the same MongoDB application code, drivers, and tools to run, manage, and scale workloads on Amazon DocumentDB without having to worry about managing the underlying infrastructure. Spring Boot provides a quick and […]