Skip to content

DBASco

Database & System Engineering Blog

  • Home
  • SQL Server
    • MSSQL Scripts
  • PowerShell
    • PowerShell Scripts
  • DBA Cheat Sheet
  • Other Posts
  • About
PowerShell: Get-ChildItem, a Comprehensive Guide
PowerShellTagged PowerShell Scripts, PowerShell TipsLeave a Comment on PowerShell: Get-ChildItem, a Comprehensive Guide

PowerShell: Get-ChildItem, a Comprehensive Guide

January 25, 2024January 26, 2024

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
OtherTagged AWS Redshift1 Comment on RedShift: Script to Show Running Queries

RedShift: Script to Show Running Queries

January 24, 2024January 24, 2024

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
OtherTagged AWS Redshift1 Comment on RedShift: Creating a User and Promoting to Superuser

RedShift: Creating a User and Promoting to Superuser

January 24, 2024January 24, 2024

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
PowerShellTagged PowerShell Functions, PowerShell Scripts, PowerShell Tips2 Comments on PowerShell Script: List Files with Sizes and Dates

PowerShell Script: List Files with Sizes and Dates

January 23, 2024February 7, 2024

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
SQL ServerTagged MSSQL DBA Tips, SQL Server DB BackupsLeave a Comment on Backing Up a Database in SQL Server Using Command

Backing Up a Database in SQL Server Using Command

January 22, 2024January 28, 2024

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
SQL ServerTagged MSSQL Scripts, SQL Server DB BackupsLeave a Comment on SQL Server Script: Get Last Backup Dates

SQL Server Script: Get Last Backup Dates

January 22, 2024February 2, 2024

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 […]

Posts pagination

Previous 1 2 3 … 8 Next

Popular Posts

DBASco (SQL DBA Blog) - 2024