A nice article on augmenting SQL2005 XML output with Namespaces

I think the internet is great. It means that if someone produces something that you think that someone you know would value from you can redirect them quite easily to the place in question. Case in point is this article by Mike Amundsen. Mike Amundsen's INETA Talks and Travels: XML Namespaces and SQL2005

How can I find which port a SQL Server 2005 Instance is listening on?

Sometimes it is useful to know which port a particular instance of SQL Server is running on, especially if you are using the default behavior where the SQL Browser automatically allocates a port to an instance. Now you can find out easily using the new dynamic management views that are provided within the SQL Server 2005 environment.

Here is a simple script which shows you where you can look