Tag: 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.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the Amazon Web Services (AWS) cloud environment. For your enterprise workloads, which depend on Amazon RDS for SQL Server, you need an effective disaster recovery (DR) strategy to help you stay up and running if an unexpected […]

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 […]

A multi-region architecture for SQL Server is often a topic of interest that comes up when working with our customers. The fundamental reasons why customers adopt a multi-region architecture approach for SQL Server deployments is: Business continuity and disaster recovery Geographically distributed customer base and improving latency for end-users This post explains the architecture patterns […]

This blog post was last reviewed or updated March, 2022. 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 […]

You can now run Microsoft SQL Server Reporting Services (SSRS) directly on an Amazon Relational Database Service (RDS) for SQL Server DB instance. You can activate SSRS on Single-AZ or Multi-AZ instances on the Standard or Enterprise editions of SQL Server 2016 or 2017. If you run SSRS on Amazon Elastic Compute Cloud (Amazon EC2), […]

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 […]

You can now configure Microsoft SQL Server Analysis Services (SSAS) in the Tabular or Multidimensional mode on Amazon RDS for SQL Server. SSAS works in the Single-AZ configuration for both Standard and Enterprise editions using either the 2016, 2017 or 2019 SQL Server Major version.

If you run SSAS on Amazon EC2, you can save on costs by supporting SSAS directly on Amazon RDS for SQL Server and consolidating those workloads to run on the same RDS DB instance as your SQL Server database. However, you must account for a performance impact if you decide to consolidate.

Amazon RDS for SQL Server now supports in-Region read replicas, which give you the ability to offload your read workloads from your primary database instance to a replica. Read replicas use the built-in distributed availability groups feature and are available for Enterprise Edition. A distributed availability group is an availability group that spans two separate […]

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]