database-tools

Here's a simple trick to reverse a text string: $text = 'Hello World' $text = $Text.ToCharArray() [Array]::Reverse($text) -join $text...

Let's assume your script may or may not need to do a privileged operation, for example write a value to a HKEY_LOCAL_MACHINE branch, depending...

There are many ways in PowerShell to create new objects. One of the more advanced approaches uses a hash table to determine object properties and...

If you need to know the number of files in a folder, there are different approaches with different advantages and disadvantages. The first one is...

Let's assume you have a CSV file with information that you need to frequently look up. For example, the CSV file may contain server names and...

Write-EventLog lets you write custom entries to event logs, and New-EventLog can add new event logs and event sources. Which raises the question:...

If you want to write plain text information to a file, don't use Out-File. Instead, use Set-Content. It is much faster: $tempfile1 =...

In a previous tip we explained how you can convert a string array into one big string. That's a prerequisite for quickly searching and replacing...

When you use Get-Content to read the content of a text file, you always get back a string array. So each line of your text file is kept separately....

When you open a MsgBox dialog from PowerShell, the dialog window may sometimes not be visible and instead appears behind the PowerShell or ISE...

If you know the IP address and subnet mask, you can take these and calculate the broadcast address. Here's a function does it for you. Simply...

Sometimes you may want to convert an IP address to its decimal value, for example, because you want to use binary operators to set bits. Here are...

To execute code in 32-bit from within a 64-bit environment (or vice versa), you can create appropriate aliases: In a 32-bit PowerShell, you create:...

Whenever a PowerShell script asks for credentials, PowerShell pops up a dialog box. You can view this by running this command: Get-Credential...

In a previous tip we showed how you can display an IPv4 address as a binary. Here's an even faster (and more cryptic) way: $ipV4 =...

If you run a large Active Directory, you should use specific Active Directory cmdlets or management functions. However, if you just want to know the...

WMI represents all kinds of physical and logical entities on your machine. It also has classes that represent user accounts which include both local...

Sometimes it may be useful to display an IPv4 address bit by bit, for example, to compare it with a subnet mask. Here's another example of just...

In PowerShell 3.0, when a parameter expects a fixed list of values, you do not need to write the complete argument. It is OK to write just as much...

Ever wanted to check whether a given user account and password was correct? Here is a little function that can help you: function Test-ADCredential...

TimeSpan objects represent a given amount of time. They are incredibly useful when you calculate with dates or times because they can represent the...

Sometimes, native commands such as net.exe return cryptic error numbers instead of full error messages. Traditionally, you could use the following...

Thanks to Shay Levy from http://powershellmagazine.com for showing how to do this: here's a small function that returns the architecture an...

Often, you may need a list of strings and want to store it in a variable. The common coding practice is like this: $MachineType =...

With Invoke-WebRequest and Invoke-RestMethod, PowerShell 3.0 now has powerful support for downloading information from the Internet as well as...

Did you know that you can use the Help Window that comes with PowerShell 3.0 and display your own text information inside of it? What's even...

If you find yourself submitting the same value for a cmdlet parameter over and over again, then PowerShell 3.0 lets you set a default value. Once...

One common headache are non-matching braces or parentheses in PowerShell scripts. So when you write a script, it is recommended to align matching...