database-tools

In the previous tip we explained how you can add a personal greeting to your PowerShell profile. This greeting can also be spoken out, provided your...

Here is a simple approach that takes an array of strings and returns a random string that you could use for custom greetings in PowerShell:...

Lately there have been reports about using Linq, a .NET query language, with PowerShell in an effort to speed up code. Until there is true Linq...

When you open a native PowerShell console in Windows 10, you can hold down CTRL+SHIFT, then move your mouse wheel, to adjust console background...

Windows is using a DNS cache, so when you change DNS servers, you need to flush the cache before the new settings take effect. PowerShell is a...

PowerShell is a friend with old console commands, so the easiest way of displaying the tree structure of a folder is the old “tree”...

In the previous tip we explained how you can download port assignments via PowerShell from IANA. This process requires Internet access and can take...

The IANA (Internet Assigned Numbers Authority) maintains a CSV file with all known port assignments. PowerShell can download this list for you: $out...

PowerShell 5 comes with Get-TimeZone which returns all defined time zones and their time offset. This is all you need for a one-liner world clock:...

Here is how PowerShell can find out whether Daylight Savings Time is currently effective – a potentially needed detail when doing GMT...

While you need administrative privileges to adjust time and date on your computer, each user can change the time zone, i.e. when you travel....

In the previous tip we illustrated how you can analyze the content of a script block and search for variables or commands. The same is possible for...

To analyze the content of a script block, you can easily examine the AST, and, for example, create a list of all variables in the code: $code = { $a...

If you need to run a PowerShell script in regular intervals, why not run it as a scheduled task? Here are some lines that help you create a new...

Here is a quick way how to find the source code of PowerShell functions: ${function:Clear-Host} | clip This would copy the Clear-Host source code to...

In a PowerShell console, you can continue to pipe to more, just like in cmd.exe, to view results page by page. However, more does not support...