How to whitelist a domain or email in Exchange 2010

If you have the Edge Transport Role installed on an Exchange 2010, mail may be rejected with the following error: #< #5.7.1 smtp; 550 5.7.1 Message rejected as spam by Content Filtering.> #SMTP#

Don’t ask me why Microsoft has buried this feature! From what I can tell, the only way to whitelist in Exchange 2010 is through the Powershell – not the GUI.  Thanks to Chris Caldwell for the fix.

Specific Address

$list = (Get-ContentFilterConfig).BypassedSenders
Set-ContentFilterConfig -BypassedSenders $list

Entire Domain

$list = (Get-ContentFilterConfig).BypassedSenderDomains
Set-ContentFilterConfig -BypassedSenderDomains ...
Continue Reading →

Renaming a VMWare Virtual Machine

This procedure was documented using VM Infrastructure 3.5 for altering ESXi 3.5 virtual machines. You may need to use Veeam to make the renaming adjustments. Could also be done via SSH.

CAUTION: If snapshots do exist and are needed, then you may need to alter the *.vmdk files to keep the chaining in place. If you do not need the snapshots, select “delete all” under the snapshot manager and perform this procedure after the host has consolidated them.


  1. Copy to ...
Continue Reading →

Importing Excel XLS to SQL SSIS error

While trying to execute an SSIS import package on a customer’s Excel file, SQL Server 2008 SP1 was returning a “truncated” error. Although, the SSIS package was set to ignore these, the execution halted and data was not written to the SQL table.

There were a number of posts including David Klein’s and Waxtadpoles regarding SQL 2005 and the “TypeGuessRows” setting in the registry.  Their suggestion was to set the value to 0 (zero), in order to force ...

Continue Reading →
Page 2 of 2 12