Author: Peter Whyte
-
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…
-
SQL Server: Searching for a String (Text) in All Tables
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…
-
Show Only the Domain of an Email Address in SQL Server
When working with email data in SQL Server, you may often need to show only the domain of an email address. Extracting email domains is useful for analyzing…
-
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).
-
Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database. It’ll show all tables largest to smallest…
-
How to Change Git Remote URL to SSH from HTTPS
This guide walks you through changing your Git authentication method from HTTPS to SSH. Using SSH eliminates the need to enter a password each time you…
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)