AWS Database Blog

Category: RDS for SQL Server

Configure Kerberos authentication in Linux clients for Amazon RDS for SQL Server with AWS Managed Microsoft AD

Amazon Relational Database Service (Amazon RDS) is a managed database service that simplifies the setup, operation, and scaling of popular database engines, including Microsoft SQL Server. In on-premises environments, SQL Server is typically configured to work with Microsoft Active Directory (AD) for NTLM and Kerberos authentication. AWS offers managed services for both components, making it […]

Optimize TempDB performance in Amazon RDS Custom for SQL Server using local instance storage

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server now supports the X2iedn instance class, which has a high memory-to-vCPU ratio and non-volatile memory express (NVMe) SSD-backed instance storage optimized for low latency, improved random I/O performance, and high sequential read throughput. With this new offering, you can now create and extend TempDB files […]

Use AWS CloudFormation for Amazon RDS for SQL Server deployments

Amazon Relational Database Service (Amazon RDS) for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the AWS cloud. It’s a fully managed, durable database built for enterprise workloads at scale and frees you up to focus on application development. Amazon RDS is integrated with AWS CloudFormation which supports […]

Back up and restore transparent data encrypted databases across accounts in Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) for SQL Server is an AWS managed database service that simplifies operating and managing Microsoft SQL Server databases. Amazon RDS for SQL Server provides value by handling the provisioning, management, and monitoring of SQL Server databases. Although this operational agility is valuable, data protection and security become even more […]

Amazon RDS Custom for SQL Server supports SQL Server 2022

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server now supports Microsoft SQL Server 2022 for Web, Standard, Enterprise and Developer Editions (via BYOM). You can use SQL Server 2022 features such as accelerated database recovery, intelligent query processing, intelligent performance, monitoring improvements, and resumable online index creations. In addition, SQL Server 2022 has […]

Native backup and restore with Amazon S3 integration on Amazon RDS Custom for SQL Server 2022

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server is a managed database service for custom and packaged applications that require access to the underlying operating system (OS) and database (DB) environment. Amazon RDS Custom for SQL Server automates the setup, operation, and scaling of databases in the cloud while granting access to the […]

Migrate SQL Server indexed views to materialized views in Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL

This is the first post of a two-part series. In this post, we discuss how to migrate SQL Server indexed views to materialized views in Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL. The second post in this series will walk you through the migration of SQL Server indexed views […]

Join SQL Server on AWS to Microsoft Entra Domain Services

Windows Authentication offers a secure and efficient mechanism for authentication management in Microsoft SQL Server. Many customers use Microsoft Entra ID (previously Azure AD) as their identity provider for Windows authentication. With the launch of support to join Amazon RDS for SQL Server to self-managed Active Directory, you can now join your Amazon Relational Database […]

Set up SSL/TLS client connections to Amazon RDS for SQL Server and Amazon RDS for Oracle

It is important to safeguard the integrity and confidentiality of communication between clients and databases. The deployment of SSL (Secure Sockets Layer) for this purpose, however, can sometimes face resistance, either due to actual complexities or perceived challenges associated with the specific tools used by individuals or organizations. In this post, we address these concerns […]

Create a SQL Server Developer Edition instance using BYOM on Amazon RDS Custom for SQL Server

Organizations are migrating their Microsoft SQL Server workloads to AWS managed database services like Amazon Relational Database Service (Amazon RDS) for SQL Server or Amazon RDS Custom for SQL Server, which makes it easy to set up, operate, and scale SQL Server deployments in the cloud. Customers often ask us how they can optimize SQL […]