database-tools

Here’s a quick tip how to switch variable content in one line: $a = 1 $b = 2 # switch variable content $a, $b = $b, $a $a $b ReTweet this...

Whenever a function returns objects with more than four properties, PowerShell formats the output as list, else as table. Before you learn a new...

If a PowerShell function needs to return more than one information kind, always make sure you wrap the pieces of information inside a rich object....

By default, when a PowerShell function exits, it “forgets” all internal variables. However, there is a workaround that creates...

If you find yourself always using the same parameter values over again, try using PowerShell default parameters. Here is how: # hash table # Key = #...

When it comes to reading large log files and, for example, extracting error messages, PowerShell can either use the low memory pipeline, or the high...

Most things can be handled by built-in PowerShell commands, but if that’s not enough, you can always resort to the internal Windows API. For...

This is part 7 of our mini-series covering PowerShell script block logging. We now just need some cleanup tool that can clear the script block...

This is part 6 of our mini-series covering PowerShell script block logging, and it’s time to address a final thing: when you execute very...

This is part 5 of our mini-series covering PowerShell script block logging. We are almost done, and what’s missing is a better way to read...

This is part 4 of our mini-series covering PowerShell script block logging. By now, you know how to read logged PowerShell code, and how to turn on...

This is part 3 of our mini-series covering PowerShell script block logging. By default, PowerShell logs only code that is considered security...

[PSCustomObject _i="0" _address="0" theme_builder_area="post_content" /][2 _i="1" _address="1" theme_builder_area="post_content" /][0 _i="2"...

Beginning with PowerShell 5, the PowerShell engine starts to log executed commands and scripts. By default, only commands considered potentially...

If you need numbers with leading zeroes, for example for server names, here are two approaches. First, you can turn the number into a string, then...