Microsoft Workloads on AWS

Tag: SQL Server on AWS

Containerize SQL Server workloads with Amazon EKS and DxOperator for Kubernetes

In this blog post, we will demonstrate a simple and effective way to deploy Microsoft SQL Server Always On Availability Group (AG) containers in Amazon Elastic Kubernetes Service (Amazon EKS) with DxOperator – SQL Server Operator for Kubernetes. Deploying database workloads in Kubernetes (K8s) is a growing trend. The Cloud Native Foundation’s 2022 Survey showed […]

Make SQL Server end of support the start of your AWS cloud journey

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

How to automate an in-place upgrade of SQL Server on Amazon EC2

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

Automate downgrading SQL Server to Developer edition on Amazon EC2

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

Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator

In this blog post, we will show you how to configure AWS Migration Hub Orchestrator using the recently-launched support for transactional log backups to reduce downtime during Microsoft SQL Server database migrations to Amazon Web Services (AWS). Customers worldwide trust AWS to run their mission-critical SQL Server databases. For SQL Server databases that are still […]

Year in review 2023: AWS for Microsoft workloads

Year in review 2023: AWS for Microsoft workloads

Celebrating 15 years of running Microsoft workloads in the cloud, longer than any other major cloud provider Before we wrap up 2023, I wanted to capture some of the highlights of the year—so I reached out to my esteemed colleague, Rajesh Rathod. Rajesh is an Amazon Elastic Cloud Compute (Amazon EC2) product leader who has […]

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

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