Peter Whyte

Category: Other

Other Blog Post Archives: Includes more random or out of context guides from an experienced SQL Server DBA, Peter Whyte.

  • 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…

    Read More

  • 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…

    Read More

  • How to Create a Test AWS RedShift Cluster

    This guide walks you through the process of creating an AWS RedShift Cluster in a personal test environment. Warning: If you’re testing AWS RedShift, be mindful of billing. Even when paused, storage charges still apply. To avoid unnecessary costs, I recommend deleting the cluster once you’re finished using…

    Read More

  • How to Create MySQL Databases & Tables

    Setting up MySQL databases and tables is a foundational skill for database administrators and developers. Whether you’re using Windows, Linux, or a cloud environment, this guide is aimed to help you create databases and tables in MySQL. Topics covered: > Create a MySQL Database> The USE DATABASE Command>…

    Read More

  • Reset Default PostgreSQL User Password

    A common scenario working with Postgres is when you have forgotten your default Postgres user password. This is the password you will have entered during your Postgres installation. This is a guide on how to reset the default Postgres user password. This should hopefully help you resolve this…

    Read More

  • How To Install PostgreSQL on Windows

    🛠️Part of the Windows Administration Complete Guide, every Windows administration post on this site, grouped by the job you are doing. PostgreSQL is a free open-source RDMS that is widely used and forked. Other than PostgreSQL itself, Redshift is the only other forked database I’ve ever touched. This…

    Read More

Start with a guide

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 having
Looking for SQL Server?

This 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
Latest posts
Browse by topic