Connecting to EC2 with Session Manager (No SSH Required)

Opening a shell on an EC2 instance through Systems Manager's Session Manager, with no SSH keys, bastion host, or open port 22 required.

Partitioning Kinesis Records with AWS IoT Payload Values

Use a customer ID from an IoT topic payload as the Kinesis partition key to preserve record order for each customer.

Querying S3 Logs with Athena and Kinesis Data Firehose

Deliver logs to S3 with Kinesis Data Firehose and query them in Athena, using custom prefixes to register partitions automatically.

Recovering Deleted Git Stashes

A dropped Git stash remains recoverable until garbage collection removes it. Learn how to find it as a dangling commit and restore its changes.

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 ST_Distance_Sphere function for calculating the great-circle distance between two geographic points.