Category Archives: Scripting

Improving performance with Get-MailboxFolderStatistics

Posted on June 19, 2012 by brian.wuchner

In a previous post I mentioned some performance improvements I made in an Exchange script that used Get-MailboxFolderStatistics. A portion of this script selected the size (in megabytes) of the top 5 folders in each users mailbox. I made a … Continue reading →

Posted in Messaging, Scripting | Leave a comment

Improving SQL Update/Insert performance

Posted on June 14, 2012 by brian.wuchner

I was recently reviewing a Powershell script that had slow performance. The script used Get-MailboxFolderStatistics to pull information from an Exchange Server environment and insert (or update) a record in a SQL database based off the email address. The code … Continue reading →

Posted in Scripting | Leave a comment

Get Regular Expression matches

Posted on June 8, 2012 by brian.wuchner

Recently I was given a task at work…someone pointed at a haystack and asked me to find a needle. Actually, the task involved reading the body of hundreds of email messages looking for telephone numbers. Regular expressions and powershell make … Continue reading →

Posted in Scripting | 1 Comment

Find upper range of AD attributes

Posted on May 25, 2012 by brian.wuchner

The other day I was working on a powershell script to copy specific Active Directory attributes to a SQL database. I wanted to see if the destination SQL fields (which were varchar 100) would be able to contain the attributes, … Continue reading →

Posted in Scripting | Leave a comment

Finding VMs that will boot into the BIOS screen

Posted on May 15, 2012 by brian.wuchner

A few months ago, after a round of Windows OS patching on development servers, a server admin notified me that their server did not come back online after the patch initiated reboot. Looking at the VM console he noted that … Continue reading →

Posted in Scripting, Virtualization | Leave a comment