macOS: Find Which Process Is Using a Specific Port
Below is a useful script when you want to see which processes are using a specific port.
Read more →Blog
Monitor Critical DNS Records for Changes Using Batch Script
If you have tier 1 services that are dependant on a few DNS records, then you may want a simple batch job to monitor these dns records for changes or deletion. The script below contains an example list of DNS entries (replace these records for the ones you want to monitor).
Read more →Mac Routing Table: Redirect Website Traffic to en0
This was a hard article to figure out the title for! Put simply, your mac book has a route table and if you want to move a specific IP address or dns from one interface to another, then follow the steps below: First find the IP address of the website that you want to re-route […]
Read more →
Sinking Car Syndrome: When Bad Architecture Is Terminal
The Sinking Car Syndrome: When Your Architecture Is Terminal There are two types of post-incident reviews in technology. The first type is genuinely useful, where you learn something, fix something,…
Read more →
SQL Server 2019 Diagnostic Queries: Glenn Berry’s Guide
Finding issues in SQL Server is not alway that easy. It can be NUMA issues, it can be DBCC settings, it can even be the CU (eg CU19). A friend…
Read more →Delete 50+ EBS Snapshots Using AWS CLI: Step-by-Step
The Amazon EC2 console allows you to delete up to 50 Amazon Elastic Block Store (Amazon EBS) snapshots at once. To delete more than 50 snapshots, use the AWS Command Line Interface (AWS CLI) or the AWS SDK. To see all the snapshots that you own in a specific region, run the following. Note, replace […]
Read more →SQL Server Missing Indexes: Query DMVs to Find Them
Most companies will have a fair amount of SQL databases and its likely that most of those databases are performing sub-optimally due to missing indexes. We can debate (for a long time) the pros and cons of indexes, but the undeniable reality is that having missing indexes on large tables create a lot of issues […]
Read more →Enable Touch ID for sudo on macOS That Survives Updates
Each day that I wake up I try and figure out if I can do less work than yesterday. With this in mind I was playing around to see if there is a way to save me typing my password each time I SUDO. It turns out this is quite a simple change… Open Terminal […]
Read more →Mac Screenshot Format: Change PNG to JPEG, GIF or PDF
There are a few things that I tweak when I get a new Macbook, one of which is the screenshot format (mainly because it doesnt natively render in Whatsapp). So I thought I would share the code snippet that you can run in Terminal to alter the default image type of your screenshots: For JPEG […]
Read more →Mirror a Static Website with wget and Host on AWS S3
I have an old website that I want to avoid the hosting costs and so just wanted to download the website and run it from an AWS S3 bucket using Cloud Front to publish the content. Below are the steps I took to do this: First download the website to your laptop Below is a […]
Read more →