AWS Database Blog

Category: Database

Best practices for migrating an Oracle database to Amazon RDS PostgreSQL or Amazon Aurora PostgreSQL: Migration process and infrastructure considerations

An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog series covers the environment and configuration setups for your source Oracle database, the AWS Database Migration (AWS DMS) service, and the target PostgreSQL […]

Read More

How to use CloudWatch metrics to decide between General Purpose or Provisioned IOPS for your RDS database

In this blog post, I talk about how you can use Amazon CloudWatch metrics to understand when you might benefit from provisioned IOPS, also known as IO1 volumes, for highest performance mission-critical database workloads. I start by setting up a test case that simulates a nonbursting consistent high-write workload. I compare performance between a database […]

Read More

Let Me Graph That For You – Part 1 – Air Routes

We’re pleased to announce the start of a multi-part series of posts for Amazon Neptune in which we explore graph application datasets and queries drawn from many different domains and problem spaces. Amazon Neptune is a fast and reliable, fully-managed graph database, optimized for storing and querying highly connected data. It is ideal for online […]

Read More

SQL Server Performance Benchmarking on AWS

With so many instance types to choose from, it can be challenging for architects and customers to choose the best ones to migrate their SQL Server workloads to AWS. Detailed specifications are available for each instance type and storage options, however all of this information may be difficult to map to real-world scenarios. We are […]

Read More

Analyze Amazon Neptune Graphs using Amazon SageMaker Jupyter Notebooks

Whether you’re creating a new graph data model and queries, or exploring an existing graph dataset, it can be useful to have an interactive query environment that allows you to visualize the results. In this blog post we show you how to achieve this by connecting an Amazon SageMaker notebook to an Amazon Neptune database. […]

Read More

Powering up Database Mail on Amazon RDS for SQL Server – How Under Armour runs Database Mail on Amazon RDS for SQL Server

Database Mail is one of the heavily used features in Microsoft SQL Server. Database Mail enables you to send messages from the SQL Server to users by using an SMTP server. The solution described here will help you use Database Mail if your SQL Server workload is on Amazon RDS. You can use Database Mail […]

Read More

RDS SQL Server has two new exciting backup and restore enhancements

Amazon Relational Database Service (Amazon RDS) is the primary mechanism for running relational databases in the AWS Cloud. Amazon RDS for SQL Server supports running SQL Server versions from SQL Server 2008 R2 to SQL Server 2017. The RDS for SQL Server team has recently released two key improvements around backup and restore for native […]

Read More

Migrating Oracle Autonomous Transactions to PostgreSQL

Migrating and operating a database includes layers of complexity and thorough planning. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility can help you manage a variety of use cases. While migrating from Oracle to PostgreSQL, it’s very common to come across Oracle Autonomous Transactions. This post explains Autonomous Transactions and how you can […]

Read More

Using Sort Keys to Organize Data in Amazon DynamoDB

It’s easy to start filling an Amazon DynamoDB table with data. However, without forethought about organizing your data, you can limit your data-retrieval options later. Data organization and planning for data retrieval are critical steps when designing a table. Without proper data organization, the only options for retrieving data are retrieval by partition key or […]

Read More