database-tools

If you just need a bunch of randomly generated MAC addresses, and you don’t care much about whether these addresses are actually valid, then...

PowerShell contains some binary operators that are not so commonly used, for example bitwise shifting. The -shl operator shifts bits to the left:...

Here is how you convert a binary text string into the corresponding integer value: $binary = "110110110" $int =...

Finally in PowerShell 5, there is support for sending results to the clipboard, and receiving results from the clipboard: PS> Get-Command -Noun...

There are two ways of replacing text in a string: the Replace() method, and the –replace operator. They work fundamentally different....

The static .NET method HtmlEncode does a good job encoding the usual character codes but fails with many special characters. To encode all...

There is a static .NET method that you can use to HTML-encode text, for example if you want the text to display correctly in HTML output: PS>...

This line finds all Word documents in your profile: Get-ChildItem -Path $home -Filter *.doc* -Recurse If you’d like, you can easily print them all....

In Germany, there are publicly available media databases with most of the TV content broadcasted by public stations. It just takes very little...

Whenever PowerShell records an error, it wraps it in an Error Record object. Here is a function that takes such an error record and extracts the...

Sometimes it requires just a couple of lines of code in PowerShell to produce highly useful helpdesk tools. Here is one that displays all currently...

Sometimes it could be useful to load all attributes from a given AD user into a hash table. This way, you could edit them, and then use Set-ADUser...

In the previous tip we illustrated how Get-FolderStructureWithPermission can document and create a list of all nested folders in a structure, along...

Sometimes you need to re-create a nested folder structure, and may also want to clone the NTFS permissions. Today we are tackling the first step:...