I've often found it helpful to use ASP.NET's Page Trace to identify performance problems with my dynamic pages. However, database queries are frequently responsible for performance problems.  Because of this, I began displaying SQL via the Page Trace. This let me see the SQL being executed to render a page. It also let me see how much time the SQL was taking to execute. As I began toying with LINQ to SQL I found myself missing the ability to see the SQL being executed to render my pages. As it turns out, it's very easy to ...

I had a project that required me to get a list of zip codes within a certain distance from a given zip code. Here is a web-based tool that does what I'm describing. I found a great post on how to do this using ColdFusion . I converted the SQL found on this page to work with MySQL and have posted it on this page. First, you are going to need to get a database that maps zip codes to longitude & latitude. I personally purchased this data for $5 from ...