database-tools

Using AD Filters with Cmdlets (Part 3)

In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results, and started...

Using AD Filters with Cmdlets (Part 2)

In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results. You learned...

Using AD Filters with Cmdlets (Part 1)

The free RSAT tools come with the ActiveDirectory PowerShell module. You can use the cmdlets from this module to retrieve AD information such as...

Creating Temp File Names

Whenever you write information to disk, it makes sense to use unique temporary file names. If you use static file names and run your code more than...

Indexes: Friend or Foe?

No matter what database you’re working with, at some point performance becomes an issue which may require further investigation into possible...

File System Stress Test

If you’d like to generate super large files for stress test purposes, you don’t have to waste time pumping data into a file to make it...

Passing Commands via Parameter

Here is a rather unusual use case for function parameters: a user can pass an output command: function Get-ProcessList { param ( [string]...

Five reasons your SQL Server is slow

Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many...

Dealing with File Encoding and BOM

When you write text content to a file, PowerShell cmdlets let you specify the encoding. Encoding determines how characters are stored, and when...

Progress Bar Timer

Here is a simple example using the PowerShell progress bar. The code displays a progress bar counting down a break. Simply adjust the number of...

Exchanging Variable Values

Here’s a quick tip how to switch variable content in one line: $a = 1 $b = 2 # switch variable content $a, $b = $b, $a $a $b ReTweet this...

1 53 54 55 56 57 159