Querying S3 Logs with Athena and Kinesis Data Firehose

Piping logs into S3 through Kinesis Data Firehose and querying them with Athena, using custom prefixes so partitions register automatically.

Recovering Deleted Git Stashes

A dropped Git stash isn't gone until garbage collection runs — how to find it as a dangling commit and cherry-pick it back.

Debugging PHP Remotely on AWS EC2 with PhpStorm and Xdebug

Remote debugging a PHP application on EC2 with PhpStorm and Xdebug, from the server-side ini settings to the IDE's path mapping.

Securely Accessing EC2 Windows Instances via SSH Port Forwarding

Reaching an EC2 Windows instance in a private subnet through an SSH bastion host, keeping RDP off the public internet entirely.

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.