Category: Other
Other Blog Post Archives: Includes more random or out of context guides from an experienced SQL Server DBA, Peter Whyte.
-
Install Claude Code on Windows, Native and in WSL
Install Claude Code on Windows with the one-line native installer or inside WSL: where claude.exe lands, the PATH fix, the first run and login, updates, and the settings.json keys worth setting on day 1.
-
Claude Code Only Keeps 30 Days of Transcripts
Claude Code silently deletes session transcripts after 30 days. Where the .jsonl files live, the cleanupPeriodDays setting in settings.json, and how to keep them without filling C:.
-
CIDR Conversion Table / Subnet Calculator
This blog post provides a quick reference table for CIDR notation, subnet masks, and host counts, making it a valuable tool for tasks like configuring security…
-
Time To Revive This Blog
As per title, I’m keen to revive this blog here at https://peter-whyte.com. I haven’t been publishing regularly for over a year, and it’s been many years since…
-
Git Log by Author
Filter git log by author, why anchoring with $ returns nothing, and counting commits.
-
Git Log Command Examples
Git log is an essential command when working with git version control. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message. It lets you know what’s changed, when it changed and by who. In this…
-
Redshift JDBC Driver Download
Need to download the Redshift JDBC client driver? Here’s how you can do it quickly:> From the AWS Redshift Console: Navigate to the Configure tab and download the JDBC driver.> Download From AWS Docs: Download the JDBC driver directly from the AWS Documentation. I’m sharing this quick guide…
-
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.
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)