Posts by /u/lockstepgo

Hi,

I wanted to share a video I put together overviewing Amazon Redshift. I’ve recently begun using it on a work project and thought it would be helpful to share some of my learnings.

The video is here: https://youtu.be/IAagaCN4CIk

Feedback / Constructive Criticism welcome!

Hi all,

I’ve been using AWS S3 for many years and am no stranger to some pretty jaw dropping S3 bills. I recently learned about S3 Lifecycle Rules and was excited to learn I can greatly reduce my costs by migrating files to certain ‘Tiers’ (Standard, Intelligent, Glacier to name a few).

Using this approach, I’ve managed to cut a $6,000 / month bill to just under $2250.

Theres a bit of a learning curve regarding how Lifecycle Rules work and how to set them up. I’ve created a video summarizing how it works (with a step by step tutorial coming soon).

Video is available here: https://youtu.be/iDYWAasynzQ Hope this helps and I’m happy to field any questions.

Hey all,

I’ve recently been dealing with some frustration trying to purchase some seemingly common products off online retailers. Getting sick of seeing ‘out of stock’ messages, I decided to build a script that would automatically detect when a retailer receives new inventory of a product, and send me a SMS Text Notification.

It ended up working really well for the first item – I got a notification in less than 30 minutes and was able to nab one. Not so good luck on a second product – been running it for over 10 hours and no dice.

I put together a video showing how I did it: https://youtu.be/6ixBJZ2vnYk I hope this shows some practical applications of using AWS and software in general.

Cheers

Hey folks,

Recently put together a tutorial video for using AWS’ newish feature, S3 Select, to run SQL commands on your JSON, CSV, or Parquet files in S3.

Ontop of it being super easy to use, using S3 Select over traditional S3 Get + Filtering has a 400% performance improvement + cost reduction. Very useful for those of you pulling down large config files in your apps.

The tutorial video is located here: https://youtu.be/yqJwN8EBCw8

Thanks!

Hey all,

I’ve used DAX quite a bit in the past to reduce our DynamoDB read capacity usage but also improve performance of our APIs.

I recently became more interested in how it works and put together a video to share my findings, which include some of the pitfalls of using DAX.

The video is available here: https://youtu.be/9deAV0yAkH8 Hope some find this useful. Cheers.

Hey folks,

I put together an overview on using Amazon Athena to perform big data analysis. Wanted to share for those of you looking for big data analysis solutions but don’t to pay infrastructure overhead.

Video is available here: https://youtu.be/1lzpeVV2hDQ