Amazon Athena SQL Cheat Sheet
A practical Amazon Athena SQL cheat sheet: partition projection, CTAS, JSON, window functions, and the cost and quoting gotchas that bite in Trino engine v3.
AWS
Amazon Web Services architecture, services and day-to-day operational practice.
Adding and extending storage on Linux
How to add a new disk and extend existing storage on Linux using LVM — covering physical servers, VMware virtual machines, and AWS EC2 EBS volumes, with a full command reference.
Dissecting a running Linux instance to build a Packer configuration
How to extract packages, services, users, and filesystem configuration from a running Linux instance and use it as the basis for a repeatable Packer AMI template.
Case study: Modernising an AWS estate with Claude Code
Modernising a production AWS estate with Claude Code – migrating Terraform state v3 to v4, the AWS provider to 6.0, and Amazon Linux, PHP and WordPress to current versions – with an honest account of where the AI tool helped and where it did not.