database-tools

In a previous tip we talked about using PowerShell Remoting to execute code on a remote machine, and how to use "using:" to carry over...

Get-ChildItem supports basic wildcards, but it does not support the rich feature set of regular expressions. If you combine Get-ChildItem with...

One common problem with enabling PowerShell Remoting on your box is public networks. As long as there are active network connection labeled as...

When you use PowerShell Remoting to execute scripts and commands on another machine, you may have run into an issue like this: $class =...

If you want to replace variables in a PowerShell script, in PowerShell ISE 3.0 you can use the following function: function Replace-Variable {...

PowershellMagazine.com has prepared a set of very useful quick reference sheets for PowerShell 3.0, the ISE editor and more. Microsoft now offers...

In a previous tip we illustrated how you can use Start-Process to launch an elevated PowerShell from within your script to do elevated tasks. The...

Active Directory and other services sometimes use a custom GUID format. To convert a GUID to that format, all blocks of the GUID need to be...

If you must make sure that a function within your script is inaccessible from outside calls, you can use this trick. Save this code as a script...

Select-String is an extremely useful cmdlet for parsing log files. You can use it to dump all lines in a text file that contain a certain keyword....

There are two ways for replacing text, and both have their advantages and pitfalls: Each string has a Replace() method which works very...

PowerShell can read and also change any part of a scheduled task. Just make sure you have appropriate permissions and run PowerShell elevated....

PowerShell 3.0 does not ship with help files. Instead, they need to be downloaded separately using Update-Help. Unfortunately, PowerShell 3.0 help...

There is a COM interface that you can use to select and dump any scheduled task definition. Just make sure you are running PowerShell with full...

Here's a simple trick to reverse a text string: $text = 'Hello World' $text = $Text.ToCharArray() [Array]::Reverse($text) -join $text...

Let's assume your script may or may not need to do a privileged operation, for example write a value to a HKEY_LOCAL_MACHINE branch, depending...

There are many ways in PowerShell to create new objects. One of the more advanced approaches uses a hash table to determine object properties and...

If you need to know the number of files in a folder, there are different approaches with different advantages and disadvantages. The first one is...

Let's assume you have a CSV file with information that you need to frequently look up. For example, the CSV file may contain server names and...

Write-EventLog lets you write custom entries to event logs, and New-EventLog can add new event logs and event sources. Which raises the question:...

If you want to write plain text information to a file, don't use Out-File. Instead, use Set-Content. It is much faster: $tempfile1 =...

In a previous tip we explained how you can convert a string array into one big string. That's a prerequisite for quickly searching and replacing...

When you use Get-Content to read the content of a text file, you always get back a string array. So each line of your text file is kept separately....