AWS Database Blog

Tag: RDS for SQL Server

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 reduces prices on Enterprise Edition in the Multi-AZ configuration

We’re pleased to announce that Amazon Relational Database Service (RDS) for SQL Server is reducing the price for both the On-Demand and Reserved DB Instances prices on Enterprise Edition Multi-AZ. The On-Demand prices have been reduced by an average by 25% across the latest generation of instance classes, which include the M5, R5, T3, X1, X1e, and Z1d. The Enterprise Edition Multi-AZ On-Demand price reduction is retroactive to July 1, 2020. The impacted Enterprise Edition Multi-AZ Reserved DB Instances purchased after August 1, 2020 will have the updated prices.

Read More

Customizing security parameters on Amazon RDS for SQL Server

You can now use database (DB) parameters to configure security protocols and ciphers on Amazon RDS for SQL Server. You can configure various security protocols and ciphers available for your RDS SQL Server instance. You can also choose to enable or disable certain TLS versions or ciphers, such as RC4 stream cipher, based on your […]

Read More

Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server

You can now configure Microsoft SQL Server Integration Services (SSIS) on Amazon Relational Database Service (RDS) for SQL Server. SSIS works on Single-AZ and Multi-AZ DB instances for both Standard and Enterprise editions using either the 2016 or 2017 SQL Server major versions. Previously, you could use RDS for SQL Server as a target source […]

Read More

Enabling distributed transaction support for domain-joined Amazon RDS for SQL Server instances

Amazon Relational Database Service (RDS) for SQL Server now supports distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). With MSDTC, you can run distributed transactions involving RDS for SQL Server DB instances. This post goes over the most common ways to run distributed transactions when using Amazon RDS for SQL Server using AWS Directory Service […]

Read More

Configuring Microsoft SQL Server Analysis Services on Amazon RDS for SQL Server

You can now configure Microsoft SQL Server Analysis Services (SSAS) in the Tabular model on Amazon RDS for SQL Server. SSAS works in the Single-AZ configuration for both Standard and Enterprise editions using either the 2016 or 2017 SQL Server Major version. If you run SSAS on Amazon EC2, you can save on costs by […]

Read More

Joining your Amazon RDS DB instances across accounts to a single shared domain

How can you simplify the setup and maintenance and reduce the costs of AWS Managed Microsoft AD directories, while also strengthen the security of your Amazon Relational Database Service (RDS) for SQL Server DB instances? AWS announced that you can now join your Amazon RDS for SQL Server DB instances deployed across multiple AWS accounts […]

Read More

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

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