Microsoft Workloads on AWS

Phil Ekins

Author: Phil Ekins

Phil Ekins is a Senior Solutions Architect in Amazon Web Services within the Microsoft technologies area and a SME on SQL Server. With over two decades of DBA experience on SQL Server and extensive experience guiding customers on Cloud Architectures, Migrations, Virtualization and HA/DR Solutions. As an AWS Architect and as a seasoned SQL Server Professional, Phil brings the DBA’s needs to the world of cloud computing.

Ola Hallengren’s SQL Server Maintenance Solution in AWS

In this blog, we will demonstrate using Ola Hallengren’s SQL Server Maintenance Solution with native backups to Amazon S3. A common task for customers is to configure database backups and maintenance jobs for their SQL Servers. Ola Hallengren’s SQL Server Maintenance Solution scripts can simplify this task by automating SQL Server database backup and maintenance […]

Automate rotating IAM credentials for SQL Server backups to Amazon S3

In this blog post, we will look at how to automate the rotation of the AWS Identity and Access Management (IAM) credentials synchronized with Microsoft SQL Server credentials to meet password rotation requirements. Solution overview The IAM Access key and Secret access key are used to create a SQL Server credential; therefore, to rotate the […]

Backup SQL Server databases to Amazon S3

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

Why AWS is the cloud that modernizes SQL Server workloads best

Modernization matters. What do we mean by modernization? AWS defines modernization as the process of progressively transforming existing applications and infrastructure to extend into higher-value, cloud-built services that unlock new business capabilities, accelerate innovation, and reduce technical debt. AWS has helped thousands of customers modernize their SQL Server workloads to technologies built for the cloud, […]