AWS Database Blog

Category: Amazon RDS

Best practices for working with Amazon Aurora Serverless

Amazon Aurora Serverless is an on-demand, autoscaling configuration for Amazon Aurora, where the database automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. It enables you to run your database in the cloud without provisioning or managing any database instances, so you can focus on building and innovating. […]

Read More

Explore what’s in store for Amazon RDS at re:Invent 2020

Join us at re:Invent 2020, a free 3-week virtual conference, from November 30 to December 18. This year’s virtual conference is going to be the industry event of the year, offering five keynotes, 18 leadership sessions, and unlimited access to hundreds of sessions, including 10 sessions on Amazon Relational Database Service (Amazon RDS). In this […]

Read More

Exploring frequently asked questions with AWS Database Solutions Architects

At Amazon, we listen to our customers and work backward from your needs. Our AWS Database Specialist Solutions Architect team helps you architect your database landscape. In this post, we address 11 frequently asked questions with videos from our Database Specialist Solutions Architects. Let’s begin the learning journey! Migrating to managed database services First, let’s […]

Read More

Using Database Mail on Amazon RDS for SQL Server

We’re happy to announce that Amazon RDS for SQL Server now fully supports SQL Server Database Mail. Before this release, you needed to use a variety of work-arounds to enable Database Mail, such as using linked servers. With the release of Database Mail for SQL Server, you can enable Database Mail seamlessly by using database parameter groups. 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 a Simple Mail Transfer Protocol (SMTP) server. In this post, you learn how to configure Database Mail and send emails from an RDS for SQL Server DB instance via Amazon Simple Email Service (Amazon SES).

Read More

Migrating your SQL Server database to Amazon RDS for SQL Server using AWS DMS

This post provides a solution for migrating your on-premises SQL Server database to Amazon RDS for SQL Server using the SQL Server backup and restore method in conjunction with AWS Database Migration Service (AWS DMS) to minimize downtime. This method is useful when you have to migrate the database code objects, including views, stored procedures, and functions, as part of the database migration.

Read More

Best practices for configuring performance parameters for Amazon RDS for SQL Server

This post discusses how to fine-tune some parameters in Amazon RDS for SQL Server to improve the performance of critical database systems. The recommended values are applicable to most environments; however, you can tune them further to fit your specific workloads. We recommend changing one or two parameters at a time and monitoring them to see the impact.

Read More

Amazon RDS for SQL Server now supports SQL Server 2019

Amazon RDS for SQL Server now supports Microsoft SQL Server 2019 for Express, Web, Standard, and Enterprise Editions. You can use SQL Server 2019 features such as Accelerated Database Recovery, Intelligent Query Processing, Intelligent Performance, Monitoring improvements, and Resumable Online Index creations. The purpose of this post is to: Summarize the new features in SQL […]

Read More

Implementing table partitioning in Oracle Standard Edition: Part 1

Oracle table partitioning is a commonly used feature to manage large tables and improve SELECT query performance. Oracle partitioning is only available in the Oracle EE Extra cost option. This post demonstrates how to implement a partitioning feature for tables in Oracle Standard Edition (Oracle SE) using a single view accessing multiple sub-tables and the INSTEAD OF trigger.

Read More

Analyzing performance management in Oracle SE using Amazon RDS for Oracle

Organizations are aggressively adopting cloud as a standard and actively evaluating their database needs. Amazon RDS for Oracle is a managed service that makes it easy to quickly create Oracle Database instances, enabling you to migrate existing on-premises workloads to the cloud. Migration from on-premises Oracle Database to Amazon RDS for Oracle is quick because […]

Read More