Microsoft Workloads on AWS

Tag: SQL Server on EC2

Reduce Microsoft SQL Server licensing costs with AWS Compute Optimizer

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

Optimizing performance and reducing licensing costs: Leveraging AWS Compute Optimizer for Amazon EC2 SQL Server instances

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

What’s new in SQL Server 2022 on AWS?

Customers running SQL Server on AWS have enjoyed running their workloads with higher reliability and performance, lowered total cost of ownership (TCO), flexible licensing options, and using the broad and deep capabilities of AWS, all while leveraging greater security and identity services. Microsoft released SQL Server 2022 for general availability (GA) on November 16th 2022, […]

Reduce failover times for SQL Server on Amazon EC2 instance using Network Load Balancer

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

How to set up disaster recovery for SQL Server Always On Availability Groups using AWS Elastic Disaster Recovery

Traditional disaster recovery methods for Microsoft SQL Server require duplication of infrastructure, operating systems, licensing and other third-party applications, rendering it a highly expensive IT project – even prohibitively expensive for some organizations. AWS Elastic Disaster Recovery (AWS DRS) provides organizations with a more modern approach to protecting Microsoft SQL Server environments: cloud-based disaster recovery […]

Deploying SQL Server Always Encrypted with secure enclaves on Amazon EC2 instances

Always Encrypted with secure enclaves is an encryption technology available in SQL Server 2019, which allows rich computations on encrypted data. With increased focus on data protection, this feature helps customers to protect sensitive data, such as credit card numbers or national identification numbers (for example, U.S. social security numbers) stored in SQL Server databases. […]