database-tools

All PowerShell Versions When you get back results from PowerShell cmdlets, the results are objects and have properties. Some properties can be...

PowerShell ISE 3 and later For documentation purposes, you may want to get a list of all variables that a PowerShell script uses. Here is a function...

PowerShell ISE 3 and later Here is a simple variable renaming function that you can use in the built-in ISE editor that ships with PowerShell 3 and...

All PowerShell Versions When you download files from the Internet, you may run into situations where the file won’t open correctly in editors....

All PowerShell Versions Each MAC address uniquely identifies a network device. The MAC address is assigned by a network equipment vendor. So you can...

All PowerShell Versions Getting the MAC of a network adapter is rather simple in PowerShell. Here is one of many ways: PS> getmac /FO CSV |...

All PowerShell Versions When you use the –split operator to split text, then the split text is consumed: PS> 'Hello, this is a text,...

All PowerShell Versions With the –split operator, you can split text at given locations. The operator expects a regular expression, so if you...

All PowerShell Versions To eliminate any duplicate space, try this regular expression: PS> '[ Man, it works! ]' -replace...

All PowerShell Versions You probably have heard about shortening long URLs. There are plenty of free services available. Here is a script that turns...

PowerShell 3.0 and later To quickly scan your PowerShell script repository and find all files that have a given function in them, try this filter:...

All PowerShell Versions If you would like to save the results of a PowerShell command to disk so that you can take it with you to another machine,...

PowerShell 3 and later Provided you have PowerShell remoting up and running on two servers, here is a simple script that illustrates how you can get...

All PowerShell Versions With PowerShell, it is really easy to download files from the Internet. Here is the code that downloads the PowerShell...

All PowerShell versions, PowerShell Console only To keep the PowerShell console open when a script is done, you may want to add a “Press Any...

All PowerShell Versions It’s never been easier to find scripts with syntax errors in them. Just use this filter: filter Test-SyntaxError {...

All PowerShell Versions Use regular expressions to check whether a string contains at least one upper case letter: $text1 = 'this is all...

All PowerShell Versions Here is a clever trick how to find out how many lines a string (not a string array!) contains: $text = @' This is some...