database-tools

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

This simple line dumps all paths to all desktops found in any of the local user profiles – just make sure you are running the line with...

Beginning in PowerShell 4, you can use the Where() and Foreach() methods in place of Where-Object and ForEach-Object whenever you do not want to use...

Here is a quick code sample that generates an array of objects using the built-in CSV parser: $csv = @' PC,Date PC82012,2017-02-28...

PowerShell uses a number of so-called type accelerators that help with long .NET type names. Instead of using...

Internal system functions are often helpful, but always make sure you fully understand what they do. A particularly popular system method is called...