database-tools

When you save date and time to text, for example when exporting to CSV, or when creating text reports, DateTime objects are converted to the date...

In the previous tip we explained how you convert date and time displayed as ticks to a true DateTime format. However, there are two different time...

Occasionally, you may run into strange date and time representations: they might be represented as a 64-bit integer like this: 636264671350358729....

In the previous tip we showed how to import digital certificates with .NET methods on any version of PowerShell. Newer versions of PowerShell come...

Installing certificate files on a computer can be done using .NET methods with any version of PowerShell. This would import a certificate file to...

Can you spot what is wrong here? PS C:\> function r { "This never runs" } PS C:\> r function r { "This never runs" } PS C:\> When you run...

Historically, the Windows file system sometimes stalls when paths grow longer than 256 characters. There is a module available at the PowerShell...

Occasionally, strings use a “Byte 0” character as a delimiter. Unlike most other delimiters, this delimiter does not show in text output...

You probably know that PowerShell supports alias names for commands. But did you know that you can define alias names for PowerShell functions...

Here is a simple and fast way of checking the operating system version: PS C:\> [Environment]::OSVersion Platform ServicePack Version...

If you want to find out whether a variable contains $Null (nothing), always make sure you keep $null on the left side of the comparison. Most of the...

If you’d like to examine and view the details of a certificate file without the need to import it into your certificate store, here is a...

To manage users and computers in your Active Directory from PowerShell, you need the ActiveDirectory module which comes as part of the free RSAT...

While there are not many built-in cmdlets to manage NTFS permissions, there is a growing list of open source PowerShell modules adding these. One...

If you’d like to know whether an array contains a given element, PowerShell provides the –contains operator. This operator does not...

LDAP filters are a fast and powerful way of retrieving information from Active Directory. However, LDAP filters use a very low-level date and time...

PowerShell function parameters support a ValidateScript attribute where you can assign PowerShell code. The code is invoked when the parameter...

When casting data (converting it to a different data type), PowerShell supports two approaches that can differ considerably. Here is an example:...

Code inside a script block can either be invoked by call operators such as „&“ or „.“, or by calling the Invoke()...

This has been part of PowerShell since version 1.0: cmdlets with verb „get“ can be invoked without the verb. So instead of...

Here is another strategy to make sure a text does not exceed a given length. In contrast to our previous tip, this code will not pad spaces in case...

If you want to make sure a text is of given length, here is an easy approach: $text = 'this is a long text' $MaxLength = 10...