Category Archives: Scripting

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

Power On virtual machine – Unable to access file since it is locked

Posted on April 30, 2012 by brian.wuchner

Several times in the past few weeks I have ran into virtual machines that do not power on because of locked files. Steps to troubleshoot this issue are described in KB10051: Virtual machine does not power on because of locked … Continue reading →