How to Install Windows Terminal
Windows Terminal is a more modern command-line tool that has many additional features. A major benefit of WT is the multiple tabs feature.
Tech Blog – All Posts (List)
Install posh-git on Windows
Posh-git is a PowerShell module that integrates with Git to show git status information on the command line, and it comes with tab completion for common commands.
Install Chocolatey on Windows
This post is a guide on installing the Chocolatey package manager on Windows by running a PowerShell command. Chocolatey allows you to manage software packages on your system with simple ‘choco’
Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database.
Change Git Remote URL to SSH from HTTPS
This post is a guide on how to change Git from using SSH to HTTPS for authentication. Using SSH for your version control system is more efficient as we do not have to enter a password every time we need to contact the remote repository.
List all Schemas, Tables & Columns in Redshift or Postgres
This post contains a SQL script that will return all schemas, tables and columns in Redshift or Postgres. I’m combining the Redshift and Postgres database blog categories here.
Create a Superuser in RedShift
Superusers in RedShift hold the permissions to perform any action in the cluster, the same access as ‘master’ or whatever you named the superuser during creation.
Drop Users in RedShift
Dropping users in Amazon Redshift is a simple task, but sometimes you may encounter an error message if the user you are trying to drop is an owner of an object in the database, such as a schema, table, or view.
Create a Test AWS RedShift Cluster
Here’s a simple guide on creating a new AWS RedShift Cluster within a personal AWS test environment. Warning, if you’re testing this AWS Service you have to be rigorous with managing the cluster for billing reasons.
Show Last Backup Times in SQL Server
If you’re running a SQL Server and you care about the data held in it, you should already be backing up the databases.
