Skip to content

Virgin Atlantic Travel Podcast

Anything to do with technology and travel always piques my interest. Here’s an extra podcast I can listen to/from work: Virgin Atlantic – Podcast Destinations [RSS]

2005 12 28 russ Uncategorized Comments Off on Virgin Atlantic Travel Podcast Permalink

LogParser

This handy utility lets you query logs just like SQL:

LogParser – Download LogParser.

Running this from the command line tells me which pages are getting 500 errors:

LogParser.exe "SELECT cs-uri-stem, count(*) FROM ex*.log where sc-status=500 group by cs-uri-stem"

Where ‘ex*.log’ are all my IIS log files…

Forensic Log Parsing with Microsoft’s LogParser – covers some useful samples for identifying suspicious activity in your IIS logs.

2005 12 08 russ utilities
web dev Comments Off on LogParser Permalink

Space Needle

Space Needle
Space Needle,
originally uploaded by russ.au.

Experimenting with the blogs feature of flickr. Things are really coming together with “Web 2.0” technologies.

2005 11 19 russ Uncategorized Comments (1) Permalink

Viewing the Locks in MS-SQL

select so.name, sli.*, sp.* 
from 
    sysobjects as so 
    join master..syslockinfo as sli on sli.rsc_objid = so.id
    join master..sysprocesses as sp on sp.spid = sli.req_spid
where xtype = 'U'

System tables reference:

2005 11 18 russ mssql Comments Off on Viewing the Locks in MS-SQL Permalink