This is a post containing a query that’ll bring back all schemas, tables, and columns in Redshift or Postgres databases. I’m combining the Redshift and Postgres database blog categories here…
Tech Blog – All Posts (List)
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.
A common SQL question is, why does anyone use WHERE 1=1 in their queries? And what does it do? The condition means WHERE TRUE, so it’s just bringing back the same query result as it would without.
PowerShell Count Rows within a .CSV FileCheck a Port is OpenDisk ManagementSet IP AddressCreate Windows Firewall RuleMap Network DriveCompress & Password Protect FilesSend an Email Count Rows within a .CSV File # Count rows within CSV files, in a specified directory.
Setup SSH Keys in WSL with Bitbucket. # Create New SSH Key# Add SSH Key to Agent# Add SSH Key to Project Create New SSH Key I’m creating a new SSH key within a linked folder, which means my SSH keys are backed up on the local machine in-case anything happens on this WSL instance…
I’ve encountered this error message when attempting to clone a git repo on a linked folder within WSL. This also happens on any mounted Windows drive when working with WSL Cloning into ‘pw-iam’…error:
Some quick notes on installing Git on Windows. I sometimes like to have installation options printed out for reference. These type of settings can usually be changed post install though.