Category: Best Practices

In this blog post, we will show you a simple and effective way to deploy Microsoft SQL Server Always On availability group containers in Amazon Elastic Kubernetes Service (Amazon EKS) with DH2i. Business-critical workloads running on SQL Server make high availability a key consideration when deploying on AWS. The challenge is that Kubernetes has a […]

In this blog post, I will show you how to update AWS Tools for PowerShell at scale within your environment by using the AWS Systems Manager Run Command. Manually updating AWS Tools for PowerShell across multiple instances can be time-consuming, inefficient, and error prone. These manual operational efforts typically result in a logistical nightmare, especially […]

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

Introduction In this blog post, I am going to show you how easy it is to deploy a secure infrastructure to manage your Amazon Elastic Cloud Compute (EC2) instances for Microsoft Windows Server through the automation provided by AWS Launch Wizard. AWS Launch Wizard offers a guided way of sizing, configuring, and deploying AWS resources […]

With Amazon Web Services (AWS), you have three main types of compute to choose from: instances, containers, and function-as-a-service. While all of them can be used to host .NET applications, choosing the right type can help you achieve the best possible architecture for your application. In this blog post, I review a few common types […]

In this blog post, we will present a sample solution and provide recommendations on how to reduce both the cost and time associated with a Microsoft Windows Server instance joining an Amazon Elastic Compute Cloud (Amazon EC2) Auto Scaling group up to 78%. Customers using Amazon EC2 Auto Scaling often desire faster scale-out times to […]

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 review advantages and disadvantages of the two storage access protocols, iSCSI and SMB, offered by Amazon FSx for NetApp ONTAP (FSx for ONTAP). For comparison purposes, we will use Microsoft SQL Server on Windows. We will provide recommendations for selecting the optimal storage access protocol for your specific scenario. […]

In this blog post, I will compare the performance of the newest releases of Babelfish for Aurora PostgreSQL and provide performance and price-performance comparisons between Babelfish and Microsoft SQL Server 2022. 1.    Introduction Babelfish for Aurora PostgreSQL is a capability of Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for […]

With the upcoming end of support for Microsoft Windows Server 2012/2012 R2 on October 10, 2023, and the ongoing challenges faced by those on Windows Server 2008/2008 R2, many organizations find themselves in a delicate position. Transitioning away from these older versions isn’t always straightforward. Some organizations are running third-party software that is not yet […]