Category: PowerShell
PowerShell blog sharing useful tips and tricks to boost efficiency, published by Peter Whyte, an experienced Microsoft SQL Server Database Administrator.
-
Testing Connectivity to Remote Server Ports with PowerShell
This post contains a demo for how to check if a port is open using PowerShell, whether you are on the latest or older versions of Windows.
-
How to Check Features Installed in SQL Server
This guide explains how to check which features are installed on a SQL Server instance.
-
Adding & Removing SQL Features via Command
This post will guide you on how to add and remove features from SQL Server via the command line. The process includes checking installed features, installing a…
-
Install/Uninstall SQL Server via Command
Installing and uninstalling SQL Server via command line can be useful, especially in environments without a GUI.
-
Guide for Setting Up Windows Server Core
When you need to setup Windows Server Core, it’s useful to first familiarize ourselves with the key PowerShell commands that configure the server.
-
Updating Help Documentation in PowerShell
Keeping your PowerShell help documentation up to date ensures you always have the latest guidance and reference materials for installed modules. The…
-
Counting Rows within CSV Files using PowerShell
This post contains a script that will help count rows within multiple CSV files using PowerShell. If you have a directory containing many CSV files, this’ll…
-
Show Available Disk Space in SQL Server
This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a…
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)