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.
This post is a guide on installing PowerShell on Ubuntu 20.04.The Ubuntu Linux distribution being used in this demo is running as a Windows Subsystem for Linux (WSL) instance.
Create a New Firewall Rule with PowerShellThis is a short post to share a PowerShell script that will create a new Windows Firewall Rule on a local computer.
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.
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.
This post is a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User rather than your own.
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.
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.