Tag: SQL Server

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.

This post was written by Ananth Mahadevan Muralidharan, Senior Architect at Agilisium Consulting, and Vignesh Selvam, Senior DevOps Engineer at Agilisium Consulting, in collaboration with Jignesh Suthar, Sr. Partner Solutions Architect at AWS. Recently, one of our (Agilisium) customers asked us to help them modernize their data analytics technology platform. They were running their data […]

Automating the process of deploying SQL Server on Amazon EC2 not only simplifies the deployment, but it also gives customers the ability to spin up additional SQL Server instances for additional capacity or spin down instances when not in use to save money. The provisioning of SQL Server is a multi-step process that is outlined in this blog.