Microsoft Workloads on AWS

Category: Compute

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 Microsoft web application deployments with GitHub Actions and Terraform

Managing infrastructure deployments and application code releases can be challenging. Manual processes often lead to delays, errors, and inconsistency across different environments. This inconsistency, known as environment drift, makes it difficult to ensure reliable deployments. As a result, teams struggle to maintain a high release velocity. In this blog post, we will show how GitHub […]

Hybrid Active Directory: Disaster recovery, cyber resiliency, and high availability solutions on AWS

In this blog post, we will present comprehensive strategies and techniques to strengthen disaster recovery and bolster cyber resilience in hybrid Microsoft Active Directory (AD) environments running in the AWS Cloud by leveraging AWS Elastic Disaster Recovery (AWS DRS) , AWS Backup, and solutions for extending AD onto Amazon Elastic Compute Cloud (Amazon EC2) instances. […]

Convert licenses of SQL Servers migrated with AWS Application Migration Service

In this blog post, I will show you how to convert Microsoft SQL Server licenses to an AWS provided license included using post-launch settings in the AWS Application Migration Service (AWS MGN). When you are migrating your SQL Servers to Amazon Web Services (AWS), you have a variety of options for using new and existing […]

Automated user creation and provisioning in Active Directory and Amazon WorkSpaces

For customers that have workloads in the AWS Cloud, a common use case is the provisioning of new user accounts in Active Directory, and subsequently, WorkSpaces for these new users. In this blog post, we will present an efficient and reusable solution to automate the creation, provisioning, and deprovisioning of Microsoft Active Directory (AD) user […]

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

Automatically create self-managed licenses in multiple accounts using tags

In this blog post, we will demonstrate how you can set up self-managed licenses to be tracked automatically through tagging. Managing licenses for software running on Amazon Elastic Compute Cloud (Amazon EC2) is critical for compliance and auditing purposes. Amazon Web Services (AWS) provides a free tool, AWS License Manager, to help you manage your licenses. However, license […]

How to generate TLS certificates for a highly available Remote Desktop Gateway Farm

Introduction In this blog post, I am going to show you how to generate, import, test, and troubleshoot a properly created Transport Layer Security (TLS) certificate for a Remote Desktop Gateway (RD Gateway) farm. Secure management of your Amazon Elastic Compute Cloud (Amazon EC2) instances for Microsoft Windows Server is a top priority for any […]