Sunday, February 24, 2008

MS XML Parser Checker

Determine version of XML Parser installed

(totally fails if no xml parser is installed!)

http://support.microsoft.com/kb/278674/

Friday, February 22, 2008

VM Performance

You might think it is stating the bleeding obvious, but...

"Have your virus scanner exclude .vhd files in the virtual machine folder on your host."

http://www.hanselman.com/blog/VMPerformanceChecklistBeforeYouComplainThatYourVirtualMachineIsSlow.aspx

Exposing Storage to a Hyper-V VM

The various methods are explained here , on Jose Barreto's Blog >

http://blogs.technet.com/josebda/archive/2008/02/14/storage-options-for-windows-server-2008-s-hyper-v.aspx

Thursday, February 21, 2008

XP : Windows Updates 'Stuck'

My work pc (xp, sp2) has automatic updates turned on (not my choice).
For the past few days I have had a some 'stuck' updates that just sit in my taskbar and won't install!

A quick google reveals I dont even need them :(
KB937060 and KB937061 are visual studio 2005 security updates for crystal reports, which I dont even have installed.

Anyway, the pc performed extremely badly whilst repeatedly failing to install these updates. A generic host process 'svchost.exe' was eating memory and periodically utilising 100% of processor time. Whilst trying to sort out the mess, I came across this script to reset Windows installer.

Steps >
1) Run this script (put in a .BAT file and run it).
2) Download essential updates from windowsupdate.com
3) Reboot


net stop wuauserv
net stop bits
rmdir /s /q %windir%\SoftwareDistribution\
REGSVR32 WUAPI.DLL /s
regsvr32 wuaueng.dll /s
REGSVR32 WUAUENG1.DLL /s
REGSVR32 ATL.DLL /s
REGSVR32 WUCLTUI.DLL /s
REGSVR32 WUPS.DLL /s
REGSVR32 WUPS2.DLL /s
REGSVR32 WUWEB.DLL /s
net start bits
net start wuauserv
wuauclt.exe /resetauthorization /detectnow

Wednesday, February 20, 2008

Tuesday, February 12, 2008

Vista SP1 Cleanup Utility - vsp1cln.exe

As if Vista didn't already take up enough disk space, it has hogged some more with the SP1 install. It uses double the amount of disk space due to leaving behind temporary installer files!

To release these files (several gig on my installation), run vsp1cln.exe from a command prompt, as below >

Blogging : Source Code Highlighter

I have changed over to Alex Gorbatchev's excellent Syntax Highlighter tool for source code blogging and have spent the evening coding back through my posts to apply it (yawn)...

this is what it does for you (excuse the old school example code) >

10 print "hello world!"
20 goto 10

here is where to find it >

http://code.google.com/p/syntaxhighlighter/

Monday, February 4, 2008

Error scripting SQL Agent jobs

" Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated. "

This occurred scripting a job from one server to another.

The solution? Create the user that owns the job first!