Category: Database

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

“We couldn’t afford to stay on our database platform. But we couldn’t afford the expense of modernizing our data tier either.” This is what Handerson Dutra, Senior Data Architect at Caylent, an AWS Partner, shared with us in a recent conversation about database modernization. “This is a common conundrum with our customers” he added. We […]

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