AWS, Cloud & Database Architecture
200 views
Banking-grade AWS deployments, multi-cloud trade-offs, and database design at scale. The architectural decisions that prevent 3am incidents.
AWS CLI Setup on Mac: Install and Configure in Minutes
You can absolutely get the following from the AWS help pages; but this is the lazy way to get everything you need for a simple single account setup. Run the two commands below to drop the package on your Mac. Then check the versions you have installed: Next you need to setup your environment. Note: […]
Read more →How to Scale Cloud Consumption Without Costly Mistakes
Introduction This article follows on from the “Cloud Migrations Crusade” blog post… A single tenancy datacenter is a fixed scale, fixed price service on a closed network. The costs of the resources in the datacenter are divided up and shared out to the enterprise constituents on a semi-random basis. If anyone uses less resources than […]
Read more →SSH EC2-User Login Fix for WordPress Bitnami Instances
So after getting frustrated (and even recreating my ec2 instances) due to a “Permission denied (publickey)”, I finally released that the worpress builds by default as set up for SSH using the bitnami account (or at least my build was). This means each time I login using ec2-user I get: Being a limited human being, […]
Read more →
How to Prevent PostgreSQL Query Stampedes: Protecting OLTP from Reporting and AI Agent Queries
A production incident that shows up again and again has the same shape. Someone, whether a human analyst, a BI tool, or increasingly an AI agent writing SQL, runs a query with no WHERE clause, an accidental cross join, or a wildly underestimated scan. Postgres has no concept of “this query looks expensive, so deprioritize […]
Read more →
What Is My IP Address? IPv4 Explained for Beginners
Firstly, let me acknowledge that there are lots of these kinds of posts on the internet. But the reason why i wrote this blog is that I wanted to force myself to consolidate the various articles I have read and my learnt knowledge in this space. I will probably update this article several times and […]
Read more →Delete 50+ EBS Snapshots Using AWS CLI: Step-by-Step
The Amazon EC2 console allows you to delete up to 50 Amazon Elastic Block Store (Amazon EBS) snapshots at once. To delete more than 50 snapshots, use the AWS Command Line Interface (AWS CLI) or the AWS SDK. To see all the snapshots that you own in a specific region, run the following. Note, replace […]
Read more →Mirror a Static Website with wget and Host on AWS S3
I have an old website that I want to avoid the hosting costs and so just wanted to download the website and run it from an AWS S3 bucket using Cloud Front to publish the content. Below are the steps I took to do this: First download the website to your laptop Below is a […]
Read more →
How SQL Server Chooses Query Plans, Why Statistics Betray You, and What To Do About It
1. The optimizer is making a bet, not a calculation Every time SQL Server compiles a query it runs an auction. The optimizer generates a handful of candidate plans, estimates the cost of each one in abstract units that roughly map to disk and CPU work, and picks the cheapest candidate it found within its […]
Read more →SQL Server Missing Indexes: Query DMVs to Find Them
Most companies will have a fair amount of SQL databases and its likely that most of those databases are performing sub-optimally due to missing indexes. We can debate (for a long time) the pros and cons of indexes, but the undeniable reality is that having missing indexes on large tables create a lot of issues […]
Read more →How to Backup MySQL on Bitnami WordPress to S3
I recently managed to explode my wordpress site (whilst trying to upgrade PHP). Anyway, luckily I had created an AMI a month ago – but I had written a few articles since then and so wanted to avoid rewriting them. So below is a method to create a backup of your wordpress mysql database to […]
Read more →
Multistage Build Optimisation: The Difference Between Amateur Containers and Production Systems
Most teams assume containers are lightweight by default, but that assumption does not survive contact with a real production system. Containers become bloated, slow, insecure, and operationally expensive when left unmanaged, and the penalties compound at scale as CI pipelines slow down, deployments lag, autoscaling becomes inefficient, and infrastructure costs quietly rise. This post goes […]
Read more →
The Contract Clause That Cannot Save You: What Switzerland’s Rejection of Palantir Means for Enterprise Technology Leaders
There is a version of this story that most technology vendors would prefer you heard. In that version, Switzerland evaluated Palantir’s data analytics platform, found it impressive, but ultimately declined due to vague concerns about national sovereignty: a regulatory sentiment, a political posture, nothing that applies to a commercial enterprise operating under normal procurement constraints. […]
Read more →