database-tools

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

Here are a couple of lines that remotely create an SMB share on a server: #requires -Version 3.0 -Modules CimCmdlets, SmbShare -RunAsAdministrator...

Here is a list of important PowerShell variables: $pshome is the path to the place where PowerShell lives. $home is the path to your personal...

Using Read-Host to ask for user information can be problematic because it prevents scripts from running unattended. A better way could be to wrap...

If your client does not sync time correctly with your domain controller, try the code below. It does require Admin privileges: w32tm.exe /resync...