How to Delete Files in PowerShell
This is a post on how to delete files in PowerShell, which will be useful when you need to delete files as part of a script in Windows.
How to Check PowerShell Version
This post is a guide on how to check your PowerShell version on a Windows computer. I’m using $PSVersionTable to get this info.
How to Automate PowerShell Scripts with Task Scheduler
This post is useful if you need to run PowerShell Scripts automatically with a set schedule in Windows. In the demos below, we’re creating new Scheduled Tasks via GUI and with PowerShell.
SQL Server Default Port
The default port for the SQL Server Engine is 1433, which is a useful thing to know if you’re working as a Database Administrator (DBA) or Database Reliability Engineering (DBRE) type role.
PowerShell Restart Services on Multiple Hosts
In this post, we’ll walk through a script that restarts services on multiple remote hosts using PowerShell. A single PowerShell command will be run on several computers at the same time.
How to Rename a Computer that Hosts SQL Server
When changing the hostname of a computer that is running SQL Server, we have to update system metadata so that remote connections and applications do not lose connectivity.
How to Find Which Process is Listening on a Port in Windows
This post is a guide on how to check what service is running for a TCP or UDP port on a Windows host computer.
How to Check Windows Firewall Status with PowerShell
This post will help you to check your local Windows Firewall status using PowerShell (whether it’s off or on for each Profile).
How to Enable Windows Firewall with PowerShell
This post is contains a demo on how to enable Windows Firewall with PowerShell in Windows Server. This might be needed if you have discovered Windows Firewall is disabled on your or multiple computers, or you might want to re-enable it after disabling this for a test (see my other post on disabling instead of enabling).
How to Disable Windows Firewall with PowerShell
This post contains a demo on how to disable Windows Firewall with PowerShell on a Windows computer. Disabling the Local Firewall on Windows is not a recommended move, and it will ultimately make your computer less secure.
