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.
Git Log Author
If you’re a Git user, you’re likely familiar with the git log command, which allows you to view the commit history for a repository.
Git Log Command
Git log is an essential command for working with Git. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message.
How to Install PowerShell on Ubuntu 20.04
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 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 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.
How to Connect to SQL Server with a Different Domain User Account
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.
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.
