SQL DBA Blog

Category: Other

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

How to Create a Test AWS RedShift Cluster

September 25, 2020

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

October 8, 2019

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

May 15, 2018

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

May 14, 2018

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 blog post is a very simple wizard run-through of installing PostgreSQL and Stack Builder on Windows for testing. # Install PostgreSQL…
Read More

Categories

Tags