database-tools

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

The cloud these days not only offers virtual machines and storage, but also brand new and exciting services such as the cognitive services. You need...