How to Set Environment Variables in PowerShell
To get environment variables in PowerShell, we can use Get-ChildItem env: to list all the environment variables and $env: to return the value of a specific environment variable.
SSMS Silent Install
This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use to administer SQL Server and to run SQL queries.
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.
Create a New Firewall Rule with PowerShell
Create a New Firewall Rule with PowerShell This is a short post to share a PowerShell script that will create a new Windows Firewall Rule on a local computer.
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.
PowerShell ForEach Loop Tutorial
Looping is a fundamental concept in PowerShell, and in programming in general. It’s needed for various situations where we need to work with one object at a time within an array/collection of objects.
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).
