Enable ECR Vulnerability Image scanning

AWS User Guide Image scanning Simple script to enable for all of our ECR repos for repo in `aws ecr

Read more

Mac startup key combinations

Referenced from: https://support.apple.com/en-us/HT201255 To use any of these key combinations, press and hold the keys

Read more

Generate Sensu Go Packages from internal Ruby Gems

Sensu-Go requires vastly different packaging for plugins than classic Sensu, and the docs are a bit sparse. Additionally, it seems

Read more

Long-Running Processes

Thanks Chandler Thompson for this! Identify Long Running ProcessesSELECT pg_stat_activity.pid, pg_class.relname, pg_locks.transactionid, pg_

Read more

Postgres, find missing indexes.

SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?'

Read more

Download RDS logs

The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile

Read more

Simple Script to read linux process limits

#!/bin/bash if [ "$#" -ne "1" ]; then echo "" echo -e "\033[01;32mLimit checker\033[00m" echo -e "\033[01;37mUsage:

Read more

Copy/Duplicate an entire Postgres database on the same server.

Stolen from TablePlus Blog, Cool product check it out here! First, lets check to see if the database has active

Read more

Fix Google's Shared Calendar issues for Apple Devices

Google has decided to treat Apple devices as 2nd class citizens in its ecosystem, you can access shared calendars, but

Read more

Create a read-only role & user in PostgreSQL

Create the role for exampledb.... Note, make sure to connect to the db you want to effect privileges for... \c

Read more