Microsoft Workloads on AWS

Tag: SQL Server on EC2

Optimizing large-scale migration of SQL Server databases to Amazon EC2 using backup metadata

In this blog post, we explore how the Microsoft SQL Server backup metadata, known as backup headers, can be leveraged when migrating from on premises to Amazon Elastic Compute Cloud (Amazon EC2). This technique is particularly useful when access to source database information is non-existent or only backup files are available with no access to […]

How to deploy a SQL Server failover cluster with Amazon EBS Multi-Attach on Windows Server

Updated on February 15, 2024. In this blog post, we’ll walk you through creating a Microsoft SQL Server failover cluster on Amazon Web Services (AWS) with Amazon Elastic Block Storage (Amazon EBS) Multi-Attach, using the recently introduced Amazon EBS Multi-Attach on io2 volumes with persistent reservations feature. We will also highlight the potential for cost […]

Automate rotating IAM credentials for SQL Server backups to Amazon S3

In this blog post, we will look at how to automate the rotation of the AWS Identity and Access Management (IAM) credentials synchronized with Microsoft SQL Server credentials to meet password rotation requirements. Solution overview The IAM Access key and Secret access key are used to create a SQL Server credential; therefore, to rotate the […]

How to manually downgrade SQL Server Enterprise edition to Developer edition on AWS and save on licensing costs

In this blog post, we will show you how to downgrade Microsoft SQL Server instances from Enterprise edition to Developer edition on Amazon Elastic Compute Cloud (Amazon EC2) instances. This post is especially useful if there are a single digit number of SQL Server instances to be downgraded. In our next blog post, we will […]

Exporting the Windows Failover Cluster log to CloudWatch

In this deep-dive blog post, we will go through a step-by-step guide on how to capture Windows Failover Cluster Event Viewer logs using Amazon CloudWatch agent and send alerts using Amazon Simple Notification Service (Amazon SNS). Introduction Windows Event Viewer logs are a crucial aspect of monitoring and troubleshooting Windows systems. However, manually reviewing these […]

Reduce Microsoft SQL Server licensing costs with AWS Compute Optimizer

In this blog post, we explore a new capability of AWS Compute Optimizer that generates Microsoft SQL Server licensing recommendations. AWS Compute Optimizer has the capability to provide customers running Microsoft SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) with licensing cost optimization recommendations, which can, result in significant SQL Server licensing cost savings. […]

Optimizing performance and reducing licensing costs: Leveraging AWS Compute Optimizer for Amazon EC2 SQL Server instances

Amazon Web Services (AWS) recently added a new feature to AWS Compute Optimizer that detects Microsoft SQL Server workloads running on Amazon Elastic Compute Cloud (Amazon EC2) using machine learning. In this blog post, I will explain how this new feature helps you identify and optimize your SQL Server workloads. Addressing challenges in rightsizing SQL Server […]

What’s new in SQL Server 2022 on AWS?

Customers running SQL Server on AWS have enjoyed running their workloads with higher reliability and performance, lowered total cost of ownership (TCO), flexible licensing options, and using the broad and deep capabilities of AWS, all while leveraging greater security and identity services. Microsoft released SQL Server 2022 for general availability (GA) on November 16th 2022, […]

Reduce failover times for SQL Server on Amazon EC2 instance using Network Load Balancer

This blog post will show you how to use AWS’ Network Load Balancer (NLB) to reduce outage time for legacy clients in response to a SQL Server Always On availability group failover A popular option to achieve SQL Server high availability (HA) is to implement SQL Server multi-subnet clustering for Always-On availability groups (AO-AG) across […]