This post contains installation notes for installing firewalld on Ubuntu Linux running within Windows Subsystem for Linux (WSL). What is Firewalld? Firewalld is a tool that helps users to manage the firewall on their Linux machine. With firewalld, users can […]
Most Common SQL Commands
Structured Query Language, or SQL, stands as the backbone of relational database management systems (RDBMS). SQL commands are the tools that empower developers, data analysts, and database administrators to interact seamlessly with databases. In this blog post, we’ll explore the […]
How to Identify Listening Ports on Windows
Discovering the processes associated with TCP or UDP ports on a Windows host is crucial for various reasons, from validating service ports to proactively addressing potential security concerns. This guide will show two efficient methods to quickly identify and analyze […]
Listing Schemas, Tables, and Columns in Redshift and Postgres
For users working with Redshift or Postgres databases, efficiently listing schemas, tables, and columns is a common need. This SQL script simplifies the process, providing a comprehensive overview of database structures. Whether you’re dealing with Redshift or Postgres, the script […]
RedShift: Script to Show Running Queries
Amazon Redshift, a powerhouse in cloud-based data warehousing, enables organizations to efficiently manage and analyze extensive datasets. For Redshift Database Administrators, understanding running queries is essential for monitoring performance, troubleshooting issues, and optimizing your database interactions. This blog post offers […]
RedShift: Creating a User and Promoting to Superuser
In Amazon RedShift, superusers wield unparalleled authority within the cluster, comparable to the access granted to the ‘master’ user or its equivalent during creation. While it’s imperative to exercise caution, granting superuser powers is occasionally necessary in local test environments […]