Category: PowerShell
PowerShell blog sharing useful tips and tricks to boost efficiency, published by Peter Whyte, an experienced Microsoft SQL Server Database Administrator.
-
Show Event Logs in PowerShell
Read Windows event logs with Get-WinEvent, and filter at the log rather than after it.
-
Open Current Folder in PowerShell
When working in a PowerShell terminal session, you might want to open Windows Explorer to view the current directory.
-
PowerShell Guide: Creating Folders and Files
This guide walks you through the steps to create new files and folders using PowerShell. Additionally, at the end I’ll show how to add text to files directly…
-
AWS CLI: List All Users in Account
Managing AWS IAM (Identity and Access Management) users is essential for maintaining security and proper control over your AWS environment. The AWS CLI…
-
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 on…
-
How to Install Posh-Git on Windows
posh-git is a PowerShell module that enhances your command line experience by displaying Git status information and providing tab completion for Git commands.
-
How to Install Chocolatey on Windows
This blog post is here to help you for installing Chocolatey on Windows using command (PowerShell).
-
Removing Quotes from a CSV File with PowerShell
This post explains how to remove quotes from a CSV file using PowerShell, a common requirement when working with CSVs that include unnecessary or problematic…
-
“.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error
Encountering this error? It’s caused by restrictive execution policies that block scripts for security reasons. This guide explains the issue and provides…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis 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- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)