database-tools

Reading XML Content

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

read more

Designing XML Documents

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

read more
The Shield

The Shield

How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are always saying no or they have to wait? I know many...

read more

Finding Out UTC Time

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

read more

Fast String Operations

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

read more

Parse an Exact Date

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

read more

Compare Versions

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

read more

Finding Executable Path

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

read more

Doing Things Forever

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

read more