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.
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.
Quick notes for installing & configuring AWS CLI (Version 2) on Windows (in PowerShell), the unified tool for managing AWS Services.
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 –
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.
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.
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.
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”.
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 &
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.
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.
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
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.
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.
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.
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“.