Satchelmouth’s Weblog
Repository of solutions for things I encounter in my field of work

Archive for the ‘Uncategorized’ Category

Post P2V NIC removal

September 13, 2009

Taken from When doing a P2V and the server has to have a static IP address after the migration, then you may recieve an error message stating that there’s an IP conflict and the ip is already configured on an existing NIC – even though only one VMware NIC is visible in network connections. […]

Script to list important details for all websites in IIS6

May 28, 2009

I have used David Wang’s original script and edited to include listing of physical path to website content and also write the results to a text file… Not written by me but my Developer, praise to be to him, saved me a ton of time fluffing about. I don’t know how elegant it is, but […]

Pretty Permalinks for WordPress in IIS6

August 11, 2008

UPDATE : // This is the default file for the site. Usually index.php $default = ‘index.php’; // The name of this file. // Set this value for the URL in Custom Error Properties of your website in IIS. // Goto: IIS Manager > Websites > [Site Name] > Properties > Custom Errors > // […]

SQL Script – 25 largest tables in a database

July 14, 2008

Courtesy of Bill Graziano at Script allows you to see the top 25 largest tables in your database. Pretty handy if you are trying to figure why your MDF file is 1.7GB !! /************************************************************************************** * * BigTables.sql * Bill Graziano ( * * v1.1 * **************************************************************************************/ declare @id int declare @type character(2) declare […]

Installing PHP 5.x on Windows 2003 Std with FastCGI

July 8, 2008

I couldn’t find a concise guide on how to install PHP 5.x on Windows 2003 with FastCGI extensions until I found this blog. To summarise, here is what is needed 1. Download FastCGI component and PHP5.x NTS zip ( NTS = non thread safe, and make sure you do NOT download the PHP installer .exe, […]

Windows 2003 FTP ban scripts

July 7, 2008

Anyone who admins a Windows 2003 server with FTP access that must be opened to all ( e.g shared web hosting server ) will have encountered brute force FTP logins to the server. If you are using FTP via IIS ( which as shit as it is, is sometimes the only option ) then you […]