database-tools

Whether you import a CSV list into PowerShell using Import-Csv, or deal with any other type of objects: how can you automatically determine the...

[System.Management.Automation.ModuleIntrinsics _i="0" _address="0.0.0.0" theme_builder_area="post_content"...

In previous tips we illustrated how you can improve loops and especially pipeline operations. To transfer this knowledge to functions, take a look...

In the previous tip we added considerable speed to a common script pattern. Now, let’s squeeze out even more performance with a pretty unusual...

Here is a common mistake found in many PowerShell scripts: $start = Get-Date $bucket = @() 1..100000 | ForEach-Object { $bucket += "I am adding...

Here is a chunk of code that demonstrates how you can store private settings in the Windows Registry: # store settings here $Path =...

If you use Outlook to organize your calendar events, here is a useful PowerShell function that connects to Outlook and dumps your calendar entries:...

How would you query for all AD users with names that start with a “e”-“g”? You shouldn’t use a client-side filter such...

Maybe you’d like to add a column with incrementing indices to your objects. Try this: $startcount = 0 Get-Service | Select-Object -Property...

In the previous tip we explained what Group-Object can do for you, and how awesome it is. Unfortunately, Group-Object does not scale well. When you...

Group-Object is an awesome cmdlet: it can easily visualize distributions. Check out the examples below: Get-Process | Group-Object -Property Company...

Occasionally, there is the need to automate tasks on websites that have been opened manually. Maybe you need to log into internal web pages first...

Starting with Windows 8 and Server 2012 R2, these operating systems ship a PowerShell module called PrintManagement. The cmdlets found in this...

Sometimes it may be clever to use simple text-based CSV format internally to bulk-create objects, especially if the original data is already...

Often, AD Administrators need to find all members of a given AD group, including nested members. Here is a code snippet that frequently surfaces in...