database-tools

Reading XML formatted text is easy when you use an XML object for it. With its method Load(), you can read in content from a file path or a URL. In...

Today we start a little mini series about XML. To create sample data to play with, you will first create a well-formed XML. While you can create XML...

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...