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 […]
Windows Terminal: How to Split Panes
This post shares a quick guide on how to split panes in Windows Terminal. Panes in Windows Terminal enhances productivity by allowing you to have multiple terminal sessions showing simultaneously within a single terminal window. To split a Windows Terminal […]
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 […]