database-tools

When you work in a global environment, it sometimes becomes necessary to translate the local time to UTC (Universal Time). The conversion is done by...

String concatenation is a frequent thing in scripts but when you use the "+=" operator to append text to a string, this slows down your...

If you need to parse a date or time information out of raw text, and if the date and time format does not adhere to the standards of your operating...

The "+=" operator is pretty convenient and can add new elements to an array. If you need this more than once, for example in a loop, then...

Sometimes you may have played around with the interactive PowerShell and suddenly realized that some of the commands you played with were pretty...

Ever wanted to compare software versions? If you do it like this, the result is off: PS> '3.12.11.100' -gt '11.1.22.91' True...

In a previous tip you have seen how an endless loop can be used to continuously monitor things - until PowerShell is closed, or a user presses...

Here is a one liner telling you the exact location of the executable of any running process. The example returns the path to the PowerShell...

If you want PowerShell to run forever, for example in order to continuously ping a site, use a simple endless loop: #requires -Version 2...

Next time you find yourself with a PowerShell console that uses the wrong keyboard layout, keep your fingers off the mouse! Do it with PowerShell...

Beginning with Windows 8.1 and Server 2012 R2, the operating system adds a wealth of new cmdlets for OS management. With these cmdlets, it is almost...

Active Directory organizes its content in classes like "user" or "computer". Each class has a predefined set of attributes, like...

The PowerShell ISE opens IntelliSense menus frequenty and helps you write code. Sometimes, however, IntelliSense does not pop up automatically,...

If you schedule a script as a scheduled task, or call it externally, and want to make sure the PowerShell process really ends, here is a brute force...

When you export objects to CSV--for example to display them in Excel--arrays won't be output correctly. Here is a simple way that converts...

Here is an easy way to get a list of all currently defined variables, their values, and their purpose. #requires -Version 2 Get-Variable |...

Sometimes you might want to run some command multiple times until it runs successfully. Here is a function that shows a way to do this: #requires...

Sometimes a script needs to save information in a persistent way. Maybe you have a list of computers that you'd want to contact, but only some...

WMI is a powerful technique to find out information about local or remote computers, and you may have used Get-WmiObject before to do so (if not,...

Cmdlets contain pure .NET code, so thanks to cmdlets, you do not need to directly touch .NET code. You can, however. Here are a number of sample...

If you want to execute more than one thing at once, there are many ways to implement this in PowerShell. One may be the use of workflows. They were...