database-tools

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

In part 3 of our mini-series about running console applications in PowerShell, here is a goodie: how can you run a console application separately...

When you directly launch a console-based application, PowerShell returns its exit code (aka Error Level) in the automatic variable $LASTEXITCODE....

When running a console-based application, it typically returns a numeric exit code. The meaning of this exit code is up to the console-based...

Here is a fun little function that uses WMI to eject your CD drive. It does so by first asking WMI for all CD drives. It then uses the explorer...

[a-z0-9 0="äöüß"()" _i="0" _address="0" theme_builder_area="post_content" /]

[Import-Csv _i="0" _address="0" theme_builder_area="post_content" /]

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