Tag: SQL Server

AWS is excited to announce our participation as a Platinum sponsor at the PASS Data Community Summit 2024, continuing our commitment to empower organizations with our data and AI services. Our mission is to help businesses migrate, optimize, and modernize Microsoft SQL Server workloads while accelerating innovation, offering unrivaled reliability, security, and cost efficiency—all within […]

The Microsoft on AWS Cost Optimization (MACO) recommendation guide is a collection of cost optimization strategies designed to help you optimize both new and existing Microsoft workloads on Amazon Web Services (AWS). It offers foundational training, cost optimization techniques, and reference architectures to build and automate cost-effective, high-performing workloads that meet business objectives. The MACO […]

A 2024 IDC Infobrief – Running SQL Server Workloads in the Cloud – reports that a clear majority of Microsoft SQL Server users chose AWS as their primary cloud provider when polled. In fact, data shows AWS is the top cloud provider of choice (52%) – more than the next six cloud providers combined. Figure […]

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