database-tools

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

If you’d like to show a default MessageBox with some buttons for the user to click, try this function: function Show-MessageBox {...

If you’d like to open a quick and dirty input box to prompt a user for some data, you could access Microsoft Visual Basic and...

There are plenty of ways how PowerShell can read in text files, and they can differ considerably in time. Check for yourself. The examples below...

If you’re working across countries and time zones, you may want to use universal time instead of local time. And to ensure that the time...

In the previous tip we illustrated how you can access detailed event log information that you retrieved via Get-EventLog by using...

When you query an event log with PowerShell, by default you get back a text message with the logged information. For example, if you’d like to know...