database-tools

Occasionally, you may have to update values in an Excel spreadsheet. PowerShell can access the Excel object model however this is quite slow. Here...

Occasionally, you may have to read information from Excel spreadsheets. PowerShell can access the Microsoft Excel object model albeit it is quite...

PowerShell can set environment variables only in its process set, so these changes will not persist and are not visible outside of PowerShell. To...

Here is a line of code that often puzzles PowerShell users: Get-Service | Select-Object -ExcludeProperty Name When you use Select-Object, its...

Here’s a code snippet that forcefully closes all open documents in the PowerShell ISE. Be aware: it closes all documents without asking to...

In the final part of our mini-series, we add pipeline awareness to our super-fast Test-OnlineFast function. You now can pipe computer names into the...

In the previous tip we created a lightning fast new PowerShell function called Test-OnlineFast which used WMI to ping any number of computers with...

In the previous tip we illustrated how WMI can ping multiple computers in a very fast way. So today, let’s wrap the code into a reusable...

In the previous tip we illustrated how WMI can ping multiple computers in a very fast way. However, the syntax was awkward. So let’s rewrite...

In the previous tip we illustrated how WMI can ping computers with a predefined timeout. WMI can do more: it can ping multiple computers lightning...

Pinging computers is a frequently needed task. The PowerShell cmdlets such as Test-Connection can do pings but do not have a timeout limit, so when...

Provided you have downloaded the PowerShell help files, there is an easy way to get help for all kinds of PowerShell topics. First, make sure you...

Select-Object is a basic cmdlet that most PowerShell users use frequently. However, it has some tricks that are not well known. In its most basic...

The RunOnce key in the Windows Registry stores all auto-starting executables. It may be empty. To check for auto-starting applications, try this:...

Here is another small script to produce random passwords consisting of a defined number of capitals, letters, numbers, and special characters:...

Here is a fun PowerShell function called Convert-PowerShellToBatch. Provide it with the path to a PowerShell script, or pipe in the results from...

Let’s assume you want to create a function that accepts a file path. There are numerous tasks that can be done with files. You may want to...

WMI is a powerful information repository – if you know the names of WMI classes: Get-CimInstance -ClassName Win32_BIOS Get-CimInstance...

The following code finds all groups a given Active Directory user is member of (including nested group memberships). The code requires the...

If your machine is connected to the internet (or VPN) via different network connections, depending on where you are, then the following two...

Windows 10 comes with all kinds of preinstalled apps and other features that may feel annoying to some. Richard Newton has created a PowerShell...

There are no built-in FTP commands in PowerShell, but you can easily download and install a free extension that provides the missing commands. Just...

In the previous tip we introduced the Get-DisplayFileSize function which automatically converts bytes to readable numbers with units such as “KB”...

The following Get-DisplayFileSize function takes any byte value and returns a nicely formatted size, using units like “MB”, “GB”, or “PB”: function...