Category: Database

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

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