Tag: Postgres
-
Why Use WHERE 1=2 in SQL
In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE value, such as WHERE 1=9. Essentially, the point is to use a condition that is guaranteed to…
-
How to Install Postgres on Ubuntu 20.04
This post is a short note on how to install Postgres on Ubuntu 20.04. I’m doing this in WSL, however this shouldn’t make any difference if you’re on the same Ubuntu version. First, lets update our local packages by running the following apt command – This Postgres installation…
-
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. Redshift is based on (forked from) PostgreSQL, meaning many core SQL commands work similarly in both. However, Redshift introduces key differences, such…
-
Creating a Linked Server for a PostgreSQL Database
This is a post on how to create a Linked Server to a PostgreSQL database. In my previous post, I created a Linked Server to another SQL Server instance. This time, it’s a link to a Postgres database. I recommend checking out my other post for pre-requisite information…
-
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…
-
How To Install PostgreSQL on Windows
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…
Useful SQL DBA Posts
SQL Server Performance
– Get Full SQL Server System Info Fast
– Quick Performance Troubleshooting Scripts
– Identify Missing & Unused Indexes
– Get Wait Stats & Top Consuming Queries
– Get Exclusive Locks on Tables
– Get Last Node Blip in SQL Server FCI
Security & Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Database Sizes & Space Used
– How to Get Table Sizes
– Get Index & Heap Fragmentation Levels
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts
Categories
Tags
Always On Availability Groups (AAG) AWS AWS Redshift Certificates & Encryption Change Data Capture (CDC) Database Admin Database Backups & Recovery Database Mirroring Deleting Data Error Messages Git Commands Importing & Exporting Data Linked Servers Linux Admin Logging & Monitoring Measuring Databases Microsoft Patching MySQL Postgres PowerShell Scripts SQL Server Agent SQL Server Database Files SQL Server Data Types SQL Server Management Studio (SSMS) SQL Server Network Connectivity SQL Server on Linux SQL Server Patching SQL Server Performance SQL Server Permissions SQL Server Processes (SPIDs) SQL Server Replication SQL Server Scripts Windows Admin Windows Authentication Windows Automation Windows Events Windows Firewall Windows Subsystem for Linux (WSL)