AWS Database Blog

Category: Database

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

Update [11/04/2020]:  We’re happy to announce that Amazon RDS for SQL Server now fully supports SQL Server Database Mail. With the release of Database Mail for SQL Server, you can enable Database Mail seamlessly by using database parameter groups. Check this blog post for more information.     Database Mail is one of the heavily […]

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

Best practices for upgrading SQL Server 2008 R2 to SQL Server 2016 on Amazon RDS for SQL Server

In preparation for the deprecation of Microsoft SQL Server 2008 R2, this blog post focuses on how to upgrade from SQL Server 2008 R2 to SQL Server 2016 on Amazon RDS for SQL Server. In addition, you can apply many of the practices in this post to all versions of SQL Server or even other […]

Read More

Your guide to Amazon DynamoDB sessions, workshops, and chalk talks at AWS re:Invent 2018

AWS re:Invent 2018 is almost here! This post includes a complete list of Amazon DynamoDB sessions, workshops, and chalk talks at AWS re:Invent 2018. Use the information on this page to help schedule your conference week in Las Vegas this year. If you still haven’t registered for re:Invent and need some help convincing your manager, consider […]

Read More

Tuning Amazon RDS for MySQL with Performance Insights

Amazon RDS Performance Insights brings an intuitive tuning interface to Amazon RDS to help you discover and investigate performance issues on your RDS databases. The look and feel of Performance Insights is the same across all database engine types, such as RDS for MySQL, RDS for PostgreSQL, and Amazon Aurora. However, every engine has a […]

Read More

Amazon DynamoDB highlights from the last 18 months you may have missed

Amazon DynamoDB is a nonrelational database that delivers reliable performance at any scale. It’s a fully managed, multiregion, multimaster database that provides consistent single-digit millisecond latency, and offers built-in security, backup and restore, and in-memory caching. This blog post recaps DynamoDB highlights from the last 18 months. Read this post to learn how to fuel your […]

Read More

Set alarms on Performance Insights metrics using Amazon CloudWatch

Amazon RDS Performance Insights recently released a feature that sends key performance metrics from Performance Insights to Amazon CloudWatch. Using this feature, you can set alerts on these metrics. When Performance Insights is enabled, it automatically sends the following three metrics to CloudWatch: DBLoad DBLoadCPU DBLoadNonCPU I describe these three metrics following. DBLoad The first […]

Read More