Category: PowerShell

PowerShell & Windows Admin Blog Archives, by Peter Whyte, an experienced SQL Server Database Administrator.

  • Get-Command in PowerShell

    Get-Command is a cmdlet in PowerShell that lets you retrieve a list of all available commands in your current session. It’s a go to tool for discovering new commands and understanding their usage and capabilities. You can use Get-Command with wildcards to filter results based on patterns. This…

    Read More


  • Create Folder If Not Exists in PowerShell

    The PowerShell script included in this blog post checks if a specific folder exists and then creates it if it does not already exist. It does this by using the Test-Path command to check for the existence of the folder and the New-Item command to create it if…

    Read More


  • Get-TimeZone in PowerShell

    The Get-TimeZone cmdlet in PowerShell retrieves the current time zone of a computer. It can also list all available time zones, which is helpful if you’re planning to make changes to the system’s time zone settings. In this post I’m sharing two examples of how to check the…

    Read More


  • 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” in the service name. We can…

    Read More


  • How to Install and Configure AWS CLI on Windows

    This post is a how-to for installing & configuring AWS CLI (Version 2) on Windows. In this guide, we’re going to download the AWS Command Line Interface installation media and run through the simple installation. Once done we’ll configure AWS CLI, which you’ll need an AWS Account to…

    Read More


  • How to Install Ubuntu 20.04 on WSL

    This guide shows how to install Ubuntu 20.04 on WSL (Windows Subsystem for Linux). Before installing a WSL Linux distribution you should have already enabled WSL on your computer. All WSL Linux distributions are available for download in the Microsoft Store. This is the easiest way to install…

    Read More


  • Show Event Logs in PowerShell

    In this post, we will explore how to use PowerShell to view event logs. We will use the Get-EventLog command to accomplish this. Specifically, we will cover the following:– List Event Types Available– Get Most Recent Events– Get Events Between a Date Range List Event Types Available To…

    Read More


  • Open Current Folder in PowerShell

    When working in a PowerShell terminal session, you might want to open Windows Explorer to view the current directory. This guide is a simple guide to demo how to open the current working directory directly from PowerShell. Using Invoke-Item to Open the Current Folder The Invoke-Item cmdlet lets…

    Read More


  • Create New Files and Folders in PowerShell

    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


  • Installing oh-my-posh On Windows

    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