In PowerShell, effective commenting is not just a best practice; it’s a skill for maintaining clean, understandable code, as it is in other coding languages. Comments serve as guides for developers, offering insights into code functionality, reasoning, and even temporary […]
Sudo for Windows
Sudo for Windows was announced recently (February 8, 2024) in the Windows Insider Preview Build 26052. This release was a great excuse for me to update my system sharply to see it in action! What the introduction of sudo on […]
How to Open PowerShell as Administrator
Running PowerShell commands with elevated privileges becomes necessary at times, especially when configuring system settings, installing software, or troubleshooting issues. In this guide, we’ll demo various methods for opening PowerShell as an administrator on different versions of Windows, including how […]
MSSQL DBA and PowerShell Cheat Sheet
This post contains useful scripts for a SQL Server Database Administrator. This page will be updated as more SQL DBA blog posts are published here at DBASco.com. SQL DBA Scripts Diagnostic Scripts for SQL Server: 1. Performance Troubleshooting Script for […]
Using PowerShell to Get Last SQL Failover Time
For SQL Server Database Administrators, tracking the timing of cluster failovers is crucial for maintaining database availability and performance. PowerShell provides a quick way to retrieve the last SQL Server failover time by reading Event Logs, which we will share […]
Windows Terminal: The Best Terminal for Windows (2024)
This article presents an unbiased perspective on the best terminal for Windows in 2024 – Windows Terminal. Whether you’re a Windows Systems Administrator or an MSSQL DBA, having a reliable and feature-rich terminal can contribute to improving efficiency, and overall […]