Upgrade PowerShell

Windows 10 does not keep PowerShell up-to-date for you. It usually ships with version 5, even though version 7 is the current version. Luckily, you can easily get the files and run the updater from within PowerShell itself. First, check your current version with a...
Query a SQL Database with PowerShell

Query a SQL Database with PowerShell

You can query a SQL database using PowerShell’s Invoke-Sqlcmd cmdlet. This cmdlet is included as part of the Sqlps module, which is installed on a computer by running SQL setup. If you need to load the module, use this command: Import-Module “sqlps”...

Send Email with PowerShell

When I cannot send email from an application on a server, I use PowerShell to send an email to determine if it is the app our outside the application where the issue is. Here is an example sending an email with the following info. You should replace this with your own...

Remove Groove from Windows 10

Groove is one of those apps that keeps popping up and advertising for itself, regardless of if you wanted it or not.  Microsoft does not give you an uninstall through the interface, but you can remove it with a simple PowerShell command. Run PowerShell as an...