Tag: SQL Server on EC2

Let’s face it. End of support (EOS) –three words that can unsettle any IT professional– is the last thing you want to hear about for your mission-critical applications. It creates additional work for you to deal with the upgrades and causes downtime for your end users. The Microsoft Windows Server and SQL Server end of […]

In this blog post, we will show you how to perform an automated in-place upgrade of your standalone Microsoft SQL Server instances installed on Amazon Elastic Compute Cloud (Amazon EC2). This solution supports upgrades to SQL Server 2016, SQL Server 2017, SQL Server 2019, and SQL Server 2022. Introduction As new versions of SQL Server […]

In this blog post, we will show you how to automate the process of downgrading from Microsoft SQL Server Enterprise or Standard edition to SQL Server Developer edition to save cost. Introduction Every day, customers benefit from the cost savings, scalability, performance, and ease of management of running SQL Server on AWS. Deploying SQL Server […]

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

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

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

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

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

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

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