Author Archives: Paul Sturm
Apache on XP incomplete page serves
On my development notebook, Apache would sometimes not fully server up pages (Coldfusion in this case). Sometimes you could view the source and see that it almost sent all the data but it was incomplete. The server logs all showed 200 status codes but my browser was not getting the full file. This happend with [...]
Using VHDmount to mount a virtual drive (VHD)
I needed to retrieve a file from a VHD. With VHDMount I could mount it, get my file, and disconnect. VHDMount is located in C:\Program Files\Microsoft Virtual Server\Vhdmount Mount file d:\virtual_drive.vhd as drive letter z: vhdmount /m "d:\virtual_drive.vhd" z Unmount all mounted drives, dicarding any changes: vhdmount /u /d All
Getting integrated authentication to work on XP/Apache 2.2/Coldfusion
I took documentation of getting SVN working on windows and the Apache documentation along with something called Moodle Download the mod_auth_sspi Module from: http://sourceforge.net/projects/mod-auth-sspi/. At the moment of writing this (2008.07.16), the current version is mod_auth_sspi 1.0.4. Select your proper version (Apache 2.0.x or Apache 2.2.x) Unzip the right file and copy mod_auth_sspi.so (it's inside [...]
Save a reboot
I recently upgraded my TortiseSVN to 1.5. This usually requires a reboot for the changes to be worked into the explorer shell. Some say you can use task manager to kill explorer.exe and, while that works, here is the way to restart explorer SAFELY thus saving a reboot: XP/2003: click on Start and select Shut Down. [...]
How to store fresh vegetables
Celery=refridgerated in foil Cucumber=refridgerated in plastic wrap Tomato=unbagged, unrefridgerated Mushrooms=brown paper bagged, refridgerated Carrots and peppers=plastic bagged, refridgerated Potato and onion=unrefridgerated, dark, cool, but not near each other
Prepare SQL Server for master database rebuild
How do you prepare for a master rebuild? This tutorial will make sure you have what you need to get yours back online easier: Part 1, Part 2, Part 3
How to Use Registry Editor to Restore Administrative Shares
Important This task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. Start [...]
Extend the Windows Server 2008 evaluation period (KB 948 472)
Snipped from http://blog.windowsvirtualization.com/wss/extend-the-windows-server-2008-evaluation-period-kb-948-472 By default Windows 2008 gives you ~60 days grace if you install it without a key. Using 'slmgr.vbs –rearm' you can extend the evaluation up to 240 days. Check out Microsoft KB 948472 "How to extend the Windows Server 2008 evaluation period" – or use the following: When the initial 60-day evaluation period [...]
Split field on space or other characters
I needed to split a field that looks like this: 'MRLMCADE—01CAB101A' into 2 fields at the '—' mark. I could not count on the '—' always starting at the 9th character so I used the following: LEFT( system_id , CHARINDEX( '—', system_id ) – 1 ) as Part_1 RIGHT( system_id , CHARINDEX( '—', REVERSE( system_id [...]
Autofix won’t fix an orphaned user
One of my logins would not repair after a restoration in my development environment. When the SQL login (mismatched user) exists and you use autofix parameter then EXEC sp_change_users_login 'Auto_Fix', 'phone' procedure will fix it without errors. But consider the situation when a user "phone" exists in the database but the login "phone" doesn't exist [...]