Tag: SQL Server

In this blog post, we explore a new capability of AWS Compute Optimizer that generates Microsoft SQL Server licensing recommendations. AWS Compute Optimizer has the capability to provide customers running Microsoft SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) with licensing cost optimization recommendations, which can, result in significant SQL Server licensing cost savings. […]

In this blog post, we introduce a strategy for scaling Microsoft SQL Server deployments on Amazon Web Services (AWS) that uses Amazon FSx, a service that provides fully managed, high-performance file systems in the cloud. This strategy increases SQL Server performance on AWS, providing 2 to 3 times as many Transactions per Minute (TPM) as […]

In this blog post, we’ll dive into two options to set up high availability for Microsoft SQL Server Integration Services (SSIS) in a Scale Out deployment model to help you figure out the best way to achieve SSIS high availability for mission-critical workloads. Introduction When you are deploying mission-critical workloads using Microsoft SQL Server databases, […]

Migrating your Microsoft workloads to the cloud requires a well-thought-out licensing strategy. AWS offers various ways to support your licensing needs and help you understand the options. Whether you aim to lower costs, enhance security, or improve the price-performance of your applications, AWS has three options to ensure you meet your objectives. The infographic illustrates […]

Did you know you can migrate a Microsoft SQL Server database from an Azure SQL Managed Instance to SQL Server on Amazon Web Services (AWS) using a COPY_ONLY backup from Azure SQL Managed Instance? Using this method is straightforward, as it copies/moves all objects in a database and it supports all editions. However, keep in […]

As more businesses move their enterprise workloads to the cloud, optimizing costs has become a top priority for them. Licensing is one of the most significant costs associated with running your Microsoft workloads on Amazon Web Services (AWS). In this blog post, I will discuss seven specific optimization strategies you can implement to help you […]

In this blog post, we will share results of Microsoft SQL Server performance testing using Amazon FSx for Windows File Server (Amazon FSx) and Amazon Elastic Block Store (Amazon EBS) with block sizes in the range of 16 KB to 64 KB to prove or disprove the common opinion that SQL Server requires 64KB block […]

Amazon Web Services (AWS) recently added a new feature to AWS Compute Optimizer that detects Microsoft SQL Server workloads running on Amazon Elastic Compute Cloud (Amazon EC2) using machine learning. In this blog post, I will explain how this new feature helps you identify and optimize your SQL Server workloads. Addressing challenges in rightsizing SQL Server […]

This blog post will show you how to use AWS’ Network Load Balancer (NLB) to reduce outage time for legacy clients in response to a SQL Server Always On availability group failover A popular option to achieve SQL Server high availability (HA) is to implement SQL Server multi-subnet clustering for Always-On availability groups (AO-AG) across […]

Join us at the PASS Data Community Summit 2022 in Seattle November 14 to 18, and we’ll show you how to accelerate the migration and modernization of your SQL Server workloads.