Category: Database

Introduction Running mission-critical Microsoft SQL Server databases on AWS requires storage infrastructure that can deliver consistent high performance, enterprise-grade data protection, and cost efficiency at scale. Database administrators and solutions architects face several persistent challenges: managing I/O performance bottlenecks during peak workloads, scaling storage seamlessly as data volumes grow, and optimizing storage costs without compromising […]

Introduction We recently announced that Amazon Relational Database Service (Amazon RDS) for SQL Server supports Microsoft SQL Server Developer Edition using your own installation media through the custom engine version (CEV) feature. This capability enables you to use SQL Server Developer Edition in development and testing environments without incurring additional licensing costs, while benefiting from […]

Introduction This blog post shows you how to back up, replicate, and restore the Microsoft SQL Server encryption key hierarchy across AWS Regions. This approach lets encrypted databases recover successfully during cross-region disaster recovery (DR) events on Amazon Elastic Compute Cloud (Amazon EC2). Cross-region DR planning for SQL Server on Amazon EC2 focuses on database […]

In modern database environments, the ability to quickly restore databases is just as critical as creating reliable backups. An 11-hour database restore window is no longer acceptable in today’s enterprise workloads. Here’s how to cut that to under 10 minutes. In our previous blog, we discussed how to create application consistent snapshot backups for Microsoft SQL […]

Microsoft SQL Server Developer edition offers organizations a cost-effective solution for their non-production database workloads on AWS. While many enterprises rely on this edition for development and pre-production testing environments, the traditional deployment process can be cumbersome – requiring manual steps like logging into Amazon Elastic Compute Cloud (Amazon EC2) instances, downloading installation media, and […]

In this blog post, we will extend the analysis of the Optimize CPUs feature provided in a previous publication to other Amazon Elastic Compute Cloud (Amazon EC2) instances suitable for deployment of Microsoft SQL Server workloads on the Amazon Web Services (AWS) Cloud. Amazon EC2 now allows customers to modify an instance’s CPU options to […]

In this blog post, we will describe how TEKsystems Global Services (TGS) worked with a university to modernize their legacy .NET Framework 3.5 applications to .NET 8 based microservices and Microsoft SQL Server (SQL Server) to Amazon Aurora PostgreSQL (Aurora PostgreSQL). TGS is an Amazon Web Services (AWS) premier tier services partner leading digital transformation […]

Introduction This blog post shows how to deploy a highly available SQL Server instance in a container using Amazon Elastic Kubernetes Service (Amazon EKS) with persistent storage backed by Amazon FSx for Windows File Server. Running databases and other stateful workloads in containers has grown significantly over the years. According to the CNCF Annual Survey […]

Resilience testing has emerged as a critical practice for organizations seeking to build and maintain resilient cloud applications. As environments grow more complex, more comprehensive testing methods become necessary. Resilience testing principles can be applied to Windows workloads on AWS to create controlled experiments that test system behavior under stress. These experiments can help you […]

This blog post introduces a new AWS feature that enables point-in-time recovery for SQL Server using EBS snapshots. It offers a detailed walkthrough for creating VSS-integrated snapshots and restoring SQL Server databases using EBS snapshots to simplify database backups and automate point-in-time restore. Introduction Amazon Web Services (AWS) recently introduced support for restoring Microsoft SQL […]