Category: Database

Introduction A common approach to implementing SQL Server Always On Failover Cluster (FCI) on Amazon EC2 is using Amazon FSx for NetApp ONTAP (FSxN). The general approach for migrating an FSxN file systems from first to second generation is using NetApp SnapMirror. That approach works well for NAS workloads (NFS/SMB file shares) where you can […]

Introduction Migrating SQL Server off Azure SQL Managed Instance usually means paying for licenses you already own. With Bring Your Own Media (BYOM) on Amazon RDS for SQL Server, you can move those databases to a fully managed AWS service and reuse your existing SQL Server licenses instead of paying twice. In this post, you […]

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