Category: Other
Other Blog Post Archives: Includes more random or out of context guides from an experienced SQL Server DBA, Peter Whyte.
-
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.
-
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…
-
Drop Users in RedShift
Dropping users in Amazon Redshift is a simple task, but sometimes you may encounter an error message if the user you are trying to drop is an owner of an…
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 (50)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)