database-tools

In a previous tip you learned how to use the string method EndsWith() to check whether a text ends with certain characters. This method does not...

You can always use the String method EndsWith(). Just make sure you convert the text to lower-case first to avoid case-sensitive comparison. This...

In a previous tip you learned how to use Group-Object to analyze text-based log files. Here's a refined snippet. It will count on which days...

Did you know that Group-Object can analyze text-based log files for you? Here's sample code that tells you how many log entries on a given day a...

Many file-related .NET Framework methods fail when the overall path length exceeds a certain length. Use low-level methods to convert lengthy paths...

To assign results to a variable and at the same time view these results in your console, place the assignment operation into parenthesis: ($result =...

In a previous tip, you learned how to use the Bitconverter type to convert hexadecimals to signed integers. Here is another way that uses type...

If you convert a hex number to a decimal, the result may not be what you want: PS> 0xFFFF 65535 PowerShell converts it to an unsigned number...

Here's a low level call that returns all time zones: PS> [System.TimeZoneInfo]::GetSystemTimeZones() Id : Dateline Standard Time DisplayName...

To map a network printer to a user profile, here's a powerful low level command: rundll32 printui.dll,PrintUIEntry /in /n...

Get-Date can extract valuable information from dates. All you need to know is the placeholder for the date part you are after. Then, repeat that...

Ever wanted to know how many days you need to work this month? Here's a clever function that lists all the weekdays you want that are in a...

Here's a simple way to convert a decimal to a hex representation, for example, if you want to display an error number in standard hexadecimal...

Let's assume you want to launch a new PowerShell session from an existing one. To carry over information from the initial session, you can use...

Ever wanted to display a dialog box from PowerShell rather than spitting out console text? Then try this function: function Show-MsgBox { param (...

Here’s a simple way of creating an ASCII table through type casting: 32..255 | ForEach-Object { 'Code {0} equals character {1}' -f $_, [Char]$_ }...