Blog Posts

• Create New Files and Folders in PowerShell

  March 31, 2021

  The New-Item cmdlet will create new files or folders in PowerShell. Amend the -ItemType parameter to File or Directory and include a Name for the file or folder. This blog post will walk through the process of creating a new file and a new folder using PowerShell. I…

  Read More

  ---

• AWS CLI – List IAM Users

  February 8, 2021

  AWS CLI – List IAM Users The aws iam list-users is a handy command for managing your AWS IAM users. It lets you get a list of all the users in your AWS account, along with some basic info about each one. You can use the –query option…

  Read More

  ---

• Get All Database Sizes & Free Space Info In SQL Server

  December 12, 2020

  Tracking database file sizes and free space within data and log files is an important part of monitoring SQL Server. This information, along with other metrics such as growth events, can help you to better predict and plan for future disk space provisioning needs. The following script provides…

  Read More

  ---

• Searching for a String Across All Tables in SQL Server

  November 30, 2020

  When working with SQL Server, you might need to find where a specific string exists in a database. This is especially useful when working with large or unfamiliar schemas. For example, you may want to check where a value like a username, email, or other data is stored…

  Read More

  ---

• Show Only the Domain of an Email Address in SQL Server

  November 27, 2020

  When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address. You can use this for things like checking invalid emails or to find out your most populous domains. In this blog post, I’ll show how to…

  Read More

  ---

• The USE Database Statement in SQL Server

  November 25, 2020

  The USE [database] command in SQL Server is used to switch the context to a specific database when running queries. This is useful when you need to work with multiple databases or change the active database during a session. When to use this statement:– When you want to…

  Read More

  ---

• Installing oh-my-posh On Windows

  November 13, 2020

  Oh-my-posh is a theme engine for PowerShell that enhances your terminal with custom themes. It integrates with posh-git to display useful indicators for Git repositories, failed commands, and admin status. This quick guide will walk you through installing oh-my-posh and setting a theme using choco. Steps to Install…

  Read More

  ---

• How to Install Windows Terminal

  November 12, 2020

  Windows Terminal (WT) is a modern command-line application for Windows that supports various shells such as PowerShell, Command Prompt, and Windows Subsystem for Linux (WSL). It offers a rich user experience with features like tabs, panes, and a customizable interface. Other benefits of Windows Terminal include Unicode /…

  Read More

  ---

• How to Install Posh-Git on Windows

  November 11, 2020

  posh-git is a PowerShell module that enhances your command line experience by displaying Git status information and providing tab completion for Git commands. This guide will show you how to install Posh Git on Windows using the Chocolatey Package Manager. As an afterthought, I’ve added notes at the…

  Read More

  ---

• Install Chocolatey on Windows

  November 10, 2020

  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’ commands. In this post after I install Chocolatey I’m installing a GUI to view all installed packages.…

  Read More

  ---