Tag: SQL Server

Disclaimer: The use of Microsoft software is subject to Microsoft’s terms. When using Microsoft Software as a customer of AWS, you are fully responsible for complying with Microsoft licensing terms. This information is only provided as a guide for your convenience, and you should not rely on its descriptions nor consider it any form of […]

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

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

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

In this blog post, we will demonstrate how to migrate a Microsoft SQL Server database on a low bandwidth network using AWS Application Migration Service (AWS MGN), AWS Snowcone, and SQL Server Log Shipping technology. Customers use different migration strategies to lift-and-shift their on-premises SQL Server workloads to the AWS Cloud. One of those approaches […]

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