SharePoint Online Document Migration Tool: FREE

The SharePoint Migration Tool lets you migrate your files from SharePoint on-premises document libraries or your on-premises file shares and easily move them to either SharePoint or OneDrive in Office 365. It is available to all Office 365 users. It only works for documents and NOT lists or any other objects.



Download tool:






Application Pool Password Recovery

I had to figure out an App Pool password. Depending on your version of IIS you can extract passwords. You just need to login remotely and have local admin access.

For IIS 6

Download resource kit from

And run Metabase Explorer, then just browse to your App Pool. Change your view settings to show Secure Data.

For IIS 7+

run this powershell command with your app pool name.

&$env:windir\system32\inetsrv\appcmd.exe list apppool “Application Pool Name” /text:ProcessModel.Password




Custom Actions for SharePoint designer workflows

I found a great set of custom actions called iLoveSharePoint. One of the actions is an Execute SQL action. Very handy for sending data from a list to SQL. I’ve started sending data to SQL so i can use Reporting Services to create dashboards to report item history. You can download the solution from codeplex:



Change BCS throttle limit of 2000 rows

One of my developers was getting a connection timeout on using an External Content Type. The real problem was that BCS has a limit of 2000 rows returned in a query. Here’s a PowerShell script to edit that limit:

$wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

 $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs


 Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

Download SharePoint 2010 Demo VM

SharePoint 2010 and Office 2010 Hyper-V VHD files are now available for download. It’s spit up in 23 files for SharePoint 2010. This includes Windows Server 2008 R2, SharePoint 2010, Office 2010, Visual Studio 2010, SQL Server 2008 R2. Theres 2 more VMs for Exchange and Communicator.


1 2