Author: Peter Whyte
-
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…
-
List all Tables & Columns in Redshift or Postgres
If you need to list all tables and columns in Redshift or Postgres, this guide provides a SQL script to retrieve schema details across all databases.
-
Creating a New User in Redshift and Promoting to Superuser
This article provides a step-by-step demo for creating a new User in Redshift and promoting it to a Superuser. I’ll include useful tips, best practices, and…
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- CLAUDE.md: Project Memory for Claude Code
- Install Claude Code on Windows, Native and in WSL
- Claude Code Only Keeps 30 Days of Transcripts
- Claude Code Permissions: Allow and Deny Rules in settings.json
- Claude Code Hooks: Run a Check After Every Edit
- Compact a WSL or Docker Desktop vhdx to Get Disk Space Back
- AI (14)
- Linux & WSL (31)
- Microsoft SQL Server (51)
- Other (15)
- PowerShell (54)
- Windows Server Admin (40)