AWS Database Blog
Tag: RDS SQL Server
Leveraging SQLAgentOperatorRole in RDS SQL Server
This blog post was reviewed and updated May 2022, to improve readability by adding more step-by-step guidance. SQL Server is a relational database management system developed by Microsoft. Amazon RDS for SQL Server makes it easier to setup, operate, and scale SQL Server deployments in the Cloud. One of the RDS SQL Server components is […]
Setting up for cross-account native backup and restore in Amazon RDS for Microsoft SQL Server
Reviewed and updated on June 2022. Amazon Relational Database Service (Amazon RDS) supports native backup and restore for Microsoft SQL Server databases. If you have multiple AWS accounts, you can perform native backup and restore across these accounts, provided that your Amazon RDS instance and the Amazon Simple Storage Service (Amazon S3) bucket are in […]
Introducing Ongoing Replication from Amazon RDS for SQL Server Using AWS Database Migration Service
We are excited to announce a new feature in AWS Database Migration Service (AWS DMS) and Amazon RDS for SQL Server that supports ongoing replication from Amazon RDS for SQL Server sources. AWS DMS helps you migrate databases to AWS quickly and more securely. It also helps you migrate data within AWS. You can migrate […]
Client-Side Encryption and Decryption of Microsoft SQL Server Backups for Use with Amazon RDS
This blog post walks you through how to securely encrypt a Microsoft SQL Server backup file and restore the encrypted backup to an Amazon RDS for SQL Server instance. You perform this process using Amazon Simple Storage Service (Amazon S3) and AWS Key Management Service (AWS KMS). This post details the encryption and steps required […]
Replicating Amazon EC2 or On-Premises SQL Server to Amazon RDS for SQL Server
Amazon RDS for SQL Server is a managed Microsoft SQL Server database service that makes it easy to set up, operate, and scale SQL Server deployments in the cloud. Amazon RDS takes away the time-consuming database administration activities so that you can focus on your schema design, query construction, query optimization, and building your application. […]
Implementing DB Instance Stop and Start in Amazon RDS
This post is from Matt Merriel at AWS partner Kloud, and Marc Teichtahl, manager for AWS Partner Solutions Architecture Australia and New Zealand. Kloud uses the new stop and start capabilities in Amazon RDS to lower costs for customers who don’t require 24×7 access to their databases during the testing and development phases of their […]
Understanding Burst vs. Baseline Performance with Amazon RDS and GP2
When we think about database storage, the dimensions that matter are the size, latency, throughput, and IOPS of the volume. IOPS stands for input/output (operations) per second, and latency is a measure of the time it takes for a single I/O request to complete. As you can imagine, latency and IOPS are closely related and […]
Integrate Amazon RDS for SQL Server DB Instances with an Existing Active Directory Domain
Vlad Vlasceanu is a solutions architect at Amazon Web Services. Last year, we launched support for Windows Authentication in Amazon RDS for SQL Server. This feature has been quite popular with customers. It lets you deploy Microsoft SQL Server-based workloads with Amazon RDS using the same centralized user management patterns that you use in your […]