Get-EventLog in PowerShell
The Get-EventLog cmdlet in PowerShell can help you view events as you would in Event Viewer, but within your PowerShell Terminal.
Tech Blog Homepage
Get-Command in PowerShell
A quick note on Get-Command in PowerShell. This cmdlet brings back a list of commands available to use in PowerShell. # get-command, better use wildcards * Get-Command test-sql*
Create Folder If Not Exists in PowerShell
A quick post to note down a script that’ll create a folder if it doesn’t already exist in PowerShell. This script utilises Test-Path which helps determin whether a path exists.
Get-TimeZone in PowerShell
The Get-TimeZone command in PowerShell returns the current Time Zone of a computer, or it can be used to list all available Time Zones which will be useful if you’re planning on making changes to this.
Get-Service in PowerShell
Get-Service is a command in PowerShell that returns a list of Services on a Computer. This post is a quick guide on running this command in a PowerShell terminal, using a wildcard ( * ) to show me my services with “SQL”
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.
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.
