Author: Andrew Baker

02 Nov 2023 AWS Cloud 👁 6 views

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 →
02 Nov 2023 Databases 👁 21 views

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 →
26 Oct 2023 Macbooks 👁 55 views

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 →
10 Oct 2023 Macbooks 👁 9 views

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 →
09 Oct 2023 AWS Cloud 👁 7 views

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 →
28 Aug 2023 AWS Cloud 👁 21 views

AWS CLI Setup on Mac: Install and Configure in Minutes

You can absolutely get the following from the AWS help pages; but this is the lazy way to get everything you need for a simple single account setup. Run the two commands below to drop the package on your Mac. Then check the versions you have installed: Next you need to setup your environment. Note: […]

Read more →
24 Aug 2023 AWS Cloud 👁 20 views

Auto Stop and Start EC2 Instances with Lambda

Below is a quick (am busy) outline on how to automatically stop and start your EC2 instances. Step 1: Tag your resources In order to decide which instances stop and start you first need to add an auto-start-stop: Yes tag to all the instances you want to be affected by the start / stop functions. Note: You […]

Read more →
18 Jul 2023 Corporate Culture 👁 12 views

Centralised vs Federated Tech Teams: How to Fix Flow

I have seen many organisations restructure their technology teams over and over, but whichever model they opt for – they never seem to be able to get the desired results with respect to speed, resilience and quality. For this reason organisations will tend to oscillate from centralised teams, which are organised around skills and reuse, […]

Read more →
26 Jun 2023 Macbooks 👁 9 views

gping Over Zero Trust Networks on macOS: Interface Guide

Once you start using a zero trust network, the first causality is normally the Ping command. The gping (Graphical Ping) command line displays a color coded realtime graph of continuous pings to a specified host and it supports specifying alternate interfaces/gateways. First lets find which interface to use. The “arp -a” command isĀ used to display […]

Read more →
30 May 2023 Macbooks 👁 19 views

Mac OS X: Find Which Network Interface Routes Traffic

If you have multiple connections on your device (and maybe you have a zero trust client installed); how do you find out which network interface on your device will be used to route the traffic? Below is a route get request for googles DNS service: If you have multiple interfaces enabled, then the first item […]

Read more →
115161722