Category: Database

Introduction This blog post shows how to deploy a highly available SQL Server instance in a container using Amazon Elastic Kubernetes Service (Amazon EKS) with persistent storage backed by Amazon FSx for Windows File Server. Running databases and other stateful workloads in containers has grown significantly over the years. According to the CNCF Annual Survey […]

Resilience testing has emerged as a critical practice for organizations seeking to build and maintain resilient cloud applications. As environments grow more complex, more comprehensive testing methods become necessary. Resilience testing principles can be applied to Windows workloads on AWS to create controlled experiments that test system behavior under stress. These experiments can help you […]

This blog post introduces a new AWS feature that enables point-in-time recovery for SQL Server using EBS snapshots. It offers a detailed walkthrough for creating VSS-integrated snapshots and restoring SQL Server databases using EBS snapshots to simplify database backups and automate point-in-time restore. Introduction Amazon Web Services (AWS) recently introduced support for restoring Microsoft SQL […]

In this blog post, we explore how to implement Microsoft SQL Server Failover Cluster Instance (FCI) on Stretch Cluster Replication in Amazon Elastic Compute Cloud (EC2). We are going to use Amazon Elastic Block Store (EBS) Multi-Attach on io2 volumes with Microsoft Windows Server Storage Replica technology as a shared storage solution across Availability Zones […]

In this blog, we will demonstrate using Ola Hallengren’s SQL Server Maintenance Solution with native backups to Amazon S3. A common task for customers is to configure database backups and maintenance jobs for their SQL Servers. Ola Hallengren’s SQL Server Maintenance Solution scripts can simplify this task by automating SQL Server database backup and maintenance […]

In this blog post, we will explore how to set up continuous database replication from Azure SQL to Amazon Relational Database Service (Amazon RDS) for SQL Server using SQL Data Sync for Azure (SQL Data Sync). Customers often replicate data across cloud platforms for various reasons, such as implementing a multicloud strategy, addressing performance challenges, […]

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

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