database-tools

PowerShell uses execution policy to determine which scripts to run. There are in fact five scopes where execution policy can be defined, and to see...

Execution policy determines what kind of scripts PowerShell will execute. You need to set execution policy to something other than Undefined,...

Classes can define so-called “static” members. Static members (properties and methods) can be invoked by the class itself and do not...

Classes can have so-called constructors. Constructors are methods that initialize a new object. Constructors are simply methods that share the name...

Methods in classes can be overloaded: you can define multiple methods with the same name but different parameters. This works similar to parameter...

One of the great advantages of classes vs. [PSCustomObject] is their ability to also define methods (commands). Here is an example that implements a...

Class properties can be assigned a mandatory type and a default value. When you instantiate an object from a class, the properties are pre-populated...

Beginning in PowerShell 5, there is a new keyword called “class”. It creates new classes for you. You can use classes as a blue print...

Working with .NET type names can be tiring because these names can be long. Here is an example: #requires -Version 2.0 Add-Type -AssemblyName...

How do you calculate the age of a person, based on birthday? You can subtract the current time delivered by Get-Date from the birthday, but the...

New-Object creates new instances of objects, and you have seen one example in the past “Speech Week”: PowerShell was able to create a...

The .NET speech engine accepts more than just plain text. If you use SpeakSsml() instead of Speak(), you can use XML to switch languages, speak...

The built-in Microsoft text to speech engine can save audio to a file. This way, you can auto-generate WAV files. Here is an example: it creates a...

In the previous tip we showed how you can tap into the text to speech converter and speak out text. Here is a way to find out the installed...

When you add the assembly “System.Speech” to PowerShell, there is a new type called “SpeechSynthesizer” which can be used to...

For path components, it is often necessary to “normalize” paths and, for example, make sure they all end with a backslash. Some try code...

Sometimes you might want to check the digits of an integer, i.e. to validate user input. Here is a really simple way using regular expressions: #...

A quick way of opening PowerShell is to launch Windows Explorer, navigate to the folder with your data, then click into the navigation bar. The...

Some cmdlets and scripts use progress bars to indicate progress. As you learned in the previous tip, progress bars cause delays, so if you...

PowerShell comes with support for progress bars. Here is a very simple example: 1..100 | ForEach-Object { Write-Progress -Activity...