Finally, I managed to get SyntaxHighlighter working.
I had tried a few things previously, but it seems that some of the tutorials I had seen were based on older versions. The joy arrived when I found this post.
Now I can post code snippets in a way which is actually readable!
SELECT
COUNT(dbid) as TotalConnections
FROM
sys.sysprocesses
WHERE
dbid > 0
Hurrah!
I'm still using Stanley Shilov's utility to escape my HTML so that I can post using these simple tags:
<pre class="brush: html">
</pre>