Category: Best Practices

In this blog post, we will share the top 10 recommendations to help you lower your costs and improve performance when running your Windows Server workloads on AWS. The first step you can take is select the right Amazon Elastic Compute Cloud (Amazon EC2) instance family, size, and licensing option for your workloads. Different instance […]

In this blog post, I will share results for Babelfish for Aurora PostgreSQL performance testing using the HammerDB database benchmarking tool. Based upon the results of testing various Aurora for PostgreSQL clusters hosting Babelfish, I will also provide recommendations on the optimal instance selection from the price-performance viewpoint. This blog post concludes with a summary […]

In this blog post, I will explore the new functionality in SQL Server 2022 that allows you to run native backups directly to Amazon Simple Storage Service (Amazon S3). I will also review the best practices for security and considerations of cost and performance. Update: We have recently published a new blog on how to […]

At re:Invent 2021, Amazon Web Services (AWS) launched the sustainability pillar as part of the AWS Well-Architected framework. It focuses on minimizing the environmental impact of running cloud workloads. Key topics include a shared responsibility model for sustainability, understanding impact, and maximizing utilization to minimize required resources and reduce downstream impact. In this blog post, […]

The high cost of Microsoft licenses for SQL Server, especially SQL Server Enterprise edition, is a point of concern for many customers planning their migration of SQL Server workloads to AWS. In this blog post, I will discuss 10 things you can do to save money with your SQL Server workloads on AWS. You have […]

Amazon CloudWatch Application Insights helps you monitor your applications and AWS infrastructure running those applications by providing easy monitoring setup and a holistic view into the health of your applications. You begin with CloudWatch Application Insights discovering the applications in your AWS Resource Groups or account. Then, it will identify and set up metrics, logs, […]

Many Windows-based applications are .NET applications. They use SQL Server in the backend to retrieve and persist data. Often in the journey to the cloud, a rehost decision is made for such a solution using a simple lift-and-shift approach. When such applications are hosted on the Amazon Elastic Compute Cloud (Amazon EC2) Windows platform, native […]

Modern data security strategies require enforcing multiple security controls – including encryption, end-user access control, monitoring, and auditing – to meet internal security policies and compliance goals. Automating the configuration and enforcement of these controls not only reduces the risk of human error and mismanagement, but also reduces management cost and overhead, especially for complex […]

By Fred Wurden, General Manager, AWS Commercial Software Service, AWS Benchmarking AWS Drives Consistent Superior Performance at a Lower Cost for Online Transaction Processing In our continued quest to be customer obsessed and offer our customers the best cloud infrastructure for running Microsoft SQL server workloads, we worked with an independent third party to run […]

Aspect-oriented programming (AOP) is an approach that enhances modularity by allowing developers to pull out cross-cutting concerns. AOP does so by adding attribute (advice) to the existing code without modifying the code itself. Classic examples of these cross-cutting concerns include caching, logging, monitoring, and, in our case, AWS X-Ray tracing. With AOP, tracing a call […]