Category: Database

In this blog post, we will show you how to configure AWS Migration Hub Orchestrator using the recently-launched support for transactional log backups to reduce downtime during Microsoft SQL Server database migrations to Amazon Web Services (AWS). Customers worldwide trust AWS to run their mission-critical SQL Server databases. For SQL Server databases that are still […]

In this blog post, we will demonstrate how to migrate a Microsoft SQL Server database on a low bandwidth network using AWS Application Migration Service (AWS MGN), AWS Snowcone, and SQL Server Log Shipping technology. Customers use different migration strategies to lift-and-shift their on-premises SQL Server workloads to the AWS Cloud. One of those approaches […]

“We couldn’t afford to stay on our database platform. But we couldn’t afford the expense of modernizing our data tier either.” This is what Handerson Dutra, Senior Data Architect at Caylent, an AWS Partner, shared with us in a recent conversation about database modernization. “This is a common conundrum with our customers” he added. We […]

In this blog post, we will show you how to downgrade Microsoft SQL Server instances from Enterprise edition to Developer edition on Amazon Elastic Compute Cloud (Amazon EC2) instances. This post is especially useful if there are a single digit number of SQL Server instances to be downgraded. In our next blog post, we will […]

In this blog post, I will compare the performance of the newest releases of Babelfish for Aurora PostgreSQL and provide performance and price-performance comparisons between Babelfish and Microsoft SQL Server 2022. 1.    Introduction Babelfish for Aurora PostgreSQL is a capability of Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for […]

Amazon Web Services (AWS) is excited to welcome our customers and partners to the PASS Data Community Summit 2023 in Seattle on November 14-17, where data professionals and experts gather to explore the latest trends, technologies, and innovations. We are delighted that AWS will continue our ongoing support of this community as a Platinum sponsor—and […]

In this deep-dive blog post, we will go through a step-by-step guide on how to capture Windows Failover Cluster Event Viewer logs using Amazon CloudWatch agent and send alerts using Amazon Simple Notification Service (Amazon SNS). Introduction Windows Event Viewer logs are a crucial aspect of monitoring and troubleshooting Windows systems. However, manually reviewing these […]

In this blog post, I will show how to move Amazon Relational Database Service (Amazon RDS) for SQL Server deployments from AWS Directory Service for Microsoft Active Directory (AWS Managed Microsoft AD) to your self-managed Microsoft AD. This blog post is not saying you should move away from AWS Managed Microsoft AD to self-manged AD. Keep […]

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

In this blog post, we’ll describe how Kloia worked with Digiturk, beIN Media Group Company, a global sports and entertainment media group, to achieve 65% cost savings by partially modernizing Digiturk’s legacy .NET Framework monolithic application to .NET-based microservices architecture. Digiturk is headquartered in Istanbul, Turkey and their services include both streaming and VoD (Video-on-Demand), […]