database-tools

PowerShell 2+ Sometimes it becomes necessary to replace special characters like German “Umlauts” in order to normalize user names or...

PowerShell 2+ Robocopy is a tool of choice to copy files, and that does not change with PowerShell. You can, however, use PowerShell to embed...

PowerShell 3+ PowerShell examines the $env:PSModulePath environment variable to find out the locations where it searches for extension modules. A...

PowerShell 3+ The popular winrm command to manage and configure PowerShell Remoting is really just a batch and a VBS file: PS> Get-Command winrm...

PowerShell 3+ In the previous tip we presented to you a “Dancing Rick ASCII”, created by Lee Holmes. Lee uses music stored on his server...

PowerShell 2 There is a good reason why Invoke-Expression is considered risky. This cmdlet executes whatever string it gets, and attackers can...

PowerShell 3+ It is fairly easy to use WPF (Windows Presentation Foundation) to create and show simple dialog windows in PowerShell. If you’d...

PowerShell 2+ Here is a fun example that illustrates how to work with timers. It adds a clock to the title bar of the PowerShell console or the...

PowerShell 2+ To move the Windows page file to a new location, you can use WMI: #requires -Version 2 $args = @{ Name = "D:\pagefile.sys" InitialSize...

When there is the need to encrypt sensitive data, scripts always face the challenge to protect the secret key used to decrypt. If the secret is to...

If you’d like to know the group memberships of the currently logged on user (the one that is running a script), you don’t need to query...

PowerShell 2+ In the previous tip we introduced variables with read-only dynamic content that updated each time the variable was read. This required...

PowerShell 2+ A little-known fact is that you can add variables to PowerShell that automatically update their content. If you need random numbers,...