Category: PowerShell
This category includes all PowerShell programming related articles and posts.
-
How to compare the server configuration and settings (sp_configure settings) of two SQL instances and identify the differences?
Have you ever wanted to compare the server configuration settings of two SQL Servers, but struggled with creating linked servers between the servers or by manually comparing the data? No longer! This post provides you with a PowerShell script, that takes two SQL Server names as input parameters, quickly compares the server configuration and highlights…
-
Reclaim wasted disk space! Have you got gigabytes of unwanted database files quietly eating storage on your SQL Server disks?
This article provides you with a script that identifies all the unwanted, unused files sitting on your SQL Server data and transaction log disks without your knowledge. It also provides you the necessary commands for deleting the junk files.
-
SQLScriptRunner – A free PowerShell tool for deploying/executing scripts across multiple SQL Servers
Need to run or deploy scripts across multiple SQL Servers in your estate? This page provides you with a free PowerShell script that can be used to deploy or execute SQL Server scripts across any number of SQL Servers in your estate.
-
How to check the correct Windows Defender antivirus (AV) exclusions are in place for SQL Server?
Most enterprises run some sort of Antivirus or endpoint protection software on their servers including on SQL Server estates. The software choice depends on things
-
SQLPing: A PowerShell tool that pings SQL Server rather than a host
As IT professionals and system administrators, we all are familiar with the command line tool Ping. We all use it, all the time, to see
-
How to programmatically check if a port is open from within SQL Server?
As a DBA, you often provision a new database to a user or a team, and provide them with SQL Server connectivity details like the
Latest Articles
