Querying S3 Logs with Athena and Kinesis Data Firehose

This note describes how to query objects stored in S3 using Athena.

Recovering Deleted Git Stashes

This note describes how to identify and recover deleted stashes.

Debugging PHP Remotely on AWS EC2 with PhpStorm and Xdebug

This note describes how to debug PHP remotely using PhpStorm and Xdebug.

Securely Accessing EC2 Windows Instances via SSH Port Forwarding

This note describes how to securely access an EC2 Windows instance in a private subnet through a bastion host in a public subnet.

Calculating Distances Between Geographic Points with MySQL 5.7

MySQL 5.7 provides the STDistanceSphere function for calculating the great-circle distance between two geographic points.