database-tools

You may have heard about PowerShell default parameter values and $PSDefaultParameterValues. When you assign a hash table to this special variable,...

If you have exported an Excel sheet to CSV and would like to import this file into PowerShell, here is how to do this: $path =...

When a PowerShell function performs system changes that may be risky, it is worth supporting the –WhatIf and –Confirm risk mitigation...

PowerShell can automatically bind values to parameters by data type matching. Here is a sample that shows what benefit this can be. Simply run this...

[AllowNull() _i="0" _address="0" theme_builder_area="post_content" /][AllowEmptyString() _i="1" _address="1" theme_builder_area="post_content" /]

PowerShell can set environment variables only in its process set, so these changes will not persist and are not visible outside of PowerShell. To...

PowerShell 5 introduces cmdlets to copy text to the clipboard, and paste it back: Set-Clipboard and Get-Clipboard. Set-Clipboard also supports the...

Whenever a user logs on to your computer, a user profile is created, and in the previous tip we explained how PowerShell can dump a list of user...

["MYDOMAINUser01" _i="0" _address="0" theme_builder_area="post_content" /]

Provided you have enabled PowerShell remoting (see our previous tips), you can easily run commands and scripts on many computers at the same time....

[targetComputerName _i="0" _address="0.0.0.0" theme_builder_area="post_content" /][targetComputerName _i="1" _address="0.0.0.1"...

If you’d like to test-drive PowerShell remoting, you need to enable it at least on the target machine (the one you’d like to visit). For...

If you’d like to persist information in your script, you might want to save your data as an object in JSON format. Here is an example: #...

If PowerShell won’t let you run a script, you may have to enable script execution first, for example like this: Set-ExecutionPolicy -Scope...

If you’d like to nicely format output text, you may want to use a PSCustomObject and output it as a formatted list like so: $infos =...

If you’d need to find out the SID for a user name, here is a useful chunk of code that does the job: $domain = 'MyDomain' $username =...

PowerShell 6 can be downloaded and run side-by-side with the official Windows PowerShell. If you’d like to test-drive it, head over to...

Out-GridView always produces a table with one object per line: Get-Process -Id $pid | Out-GridView Occasionally, it would be more helpful to display...

If you’d like to format information to given culture standards, this is really simple by using ToString() and the appropriate target...

Let’s assume you received data like numbers or date as text. Whenever information is reduced to text, you are challenged with culture-specific...

There are many different ways how objects can be transformed into text. In case you sometimes get confused, here is a quick refresher. Take a look:...

Execution policy can prevent scripts from running. It is designed to be a user preference setting, so you should always be able to change the...