Here is a list of tools I use on a semi-regular basis. I’ll update it every now and then.
SQL Format by Red Gate
This will take nasty sql and format it to be pretty.
This will remove extra whitespace characters like tab and carriage returns. Useful for turning multiple lines of text into one long single line of text.
xmlGrid.net – raw XML visualization
Here is a great resource for visualizing raw XML. Since .NET has such great serialization support, we persist many objects to XML as we transfer them between processes.