PowerShell, a powerful command-line tool and scripting language, provides a versatile set of commands to manage and automate tasks in Windows environments. One of the most frequently used commands is Get-ChildItem (alias: gci). In this guide, we’ll delve into the […]
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 […]
PowerShell Script: List Files with Sizes and Dates
In this blog post, we’ll explore a simple and practical PowerShell script that helps you list files in a directory along with their sizes and creation dates. This script provides a straightforward way to gain insights into your file system, […]
Backing Up a Database in SQL Server Using Command
In the world of database management, ensuring the safety and integrity of your data is paramount. One crucial aspect of this is regularly backing up your SQL Server databases. In this guide, we’ll walk you through the process of backing […]
SQL Server Script: Get Last Backup Dates
Staying informed about the last backup times is crucial for maintaining data integrity and ensuring rapid recovery in case of unexpected incidents. In this blog post, we’ll share a SQL Server script that provides a comprehensive view of the last […]