Category: PowerShell

PowerShell blog sharing useful tips and tricks to boost efficiency, published by Peter Whyte, an experienced Microsoft SQL Server Database Administrator.


  • Advanced File and Folder Creation with PowerShell

    This post contains an advanced guide for creating and managing files and folders in PowerShell. It builds on the basics introduced in my previous post…

    Read More


  • How to Manage S3 Buckets with AWS CLI

    This is a post on how to help manage S3 Buckets with AWS CLI, and to help explain some local Operating System (OS) considerations when running such commands.

    Read More


  • Managing Old Files with PowerShell

    Managing disk space is a common task for IT professionals, especially when dealing with folders that accumulate temporary or outdated files. Using simple…

    Read More


  • Using Get-EventLog in PowerShell

    The Get-EventLog cmdlet allows you to view event logs directly in your PowerShell terminal, similar to using Event Viewer. Below are some quick examples to get started:1. List Available Event Log Types2. Show Events by Count3. Filter Events by Message4. View Full Message of an Event 1. List…

    Read More


  • 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…

    Read More


  • Create Folder If Not Exists in PowerShell

    Creating folders programmatically can streamline tasks and ensure that required directory structures are in place.

    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…

    Read More


  • Get-Service in PowerShell

    The Get-Service command in PowerShell is the tool for listing, filtering, and managing the services running on a computer. This quick guide is aimed at helping…

    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.

    Read More


Looking for SQL Server?

This site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.

sqldba.blogScripts, error library, wait types, SSMS
Browse by topic