How to Install & Configure AWS CLI on Ubuntu
This is a post on how to install and configure AWS CLI (version 1) on Ubuntu (20.04). I’ll just jump right into it and start off by updating my local packages.
Tech Blog – All Posts (Grid)
How to Install and Configure AWS CLI on Windows
Quick notes for installing & configuring AWS CLI (Version 2) on Windows (in PowerShell), the unified tool for managing AWS Services.
How to Install Ubuntu 20.04 on WSL
This is a guide on how to install the Ubuntu 20.04 distro on Windows Subsystem for Linux (WSL). Links to various linux distros can be found here –
How to Unregister a Linux Distro in WSL
This is a post on how to unregister a Linux distro in Windows Subsystem for Linux (WSL) – useful for cleaning up an old installation for reinstalling a-fresh.
How to Set a Default Linux Distro in WSL
This is a post on how to set our default Linux distribution in Windows Subsystem for Linux (WSL). If you’re making the most of WSL and have more than one Linux distribution installed, this post might come in handy.
Show Event Logs in PowerShell
This is a post on how to show event logs in PowerShell using Get-EventLog. First up I’m showing a list of the types of event log available on my system.
Open Current Folder in PowerShell
This post is a quick guide on how you can open your current folder in PowerShell. Invoke-Item “performs the default action on the specified item”.
Redshift JDBC Driver Download
A handy post to note down the JDBC client driver download. I’m frequently in need of this myself. You can download the JDBC driver from the AWS Docs and then gain your cluster endpoint address from the main Redshift dashboard window Instead of doing the above, you navigate to the Configure tab in the Redshift console and download the JDBC driver &
Create New Files and Folders in PowerShell
This post is some quick notes on creating a new files and directories using PowerShell. There’s 3 wee highlights:# Create a New Directory# Create a New (.txt) File# Add Text to the New File Create a New Directory New-Item is the command.
Find String in Tables in SQL Server
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
Show Only the Domain of an Email Address in SQL Server
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
USE Command in SQL Server
The Use command in SQL Server is a way to change context to a specified database, which I often refer to this as scoping to a database for a query.
Change Default Database in SQL Server
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
Install oh-my-posh On Windows
Oh-my-posh is a theme engine for PowerShell that’s separate from your default PowerShell console. It’s powered by posh-git and has status indications for git, failed, and admin commands.
Install Windows Terminal (WT)
Windows Terminal is a more modern command-line tool that has features including “multiple tabs, panes, Unicode and UTF-8 character support, a GPU accelerated text rendering engine, and the ability to create your own themes and customize text, colors, backgrounds, and shortcuts“.
