http://dev.forrestcroce.com Innovative Concepts and Open Source Goodies Sat, 16 Jan 2010 00:17:05 +0000 http://backend.userland.com/rss092 en The .NET Framework is pretty feature rich, helping developers put applications together quickly. A glaring omission, however, is support for anything to do with geography. I recently had a need to deal with distances between points in GPS files, calculated using the haversine formula, and came up with ... http://dev.forrestcroce.com/a-geographic-distance-class-in-c/2010-01-16/ Our last post described how to see what another connection to a SQL Server is doing, with a user-defined function, dbo.InputBuffer. Given a spid, the function returns the SQL text being run on that connection - or the last command received from the connection, depending on which version you ... http://dev.forrestcroce.com/dbo-query-plan-function/2009-08-19/ Background Most people who use SQL Server regularly, know about the wonderful DBCC InputBuffer command. If you're not a SQL aficionado, you can easily find out what other connections "are doing" when one of them starts causing problems. Checking the input buffer - how commands are received by the ... http://dev.forrestcroce.com/dbo-inputbuffer-function/2009-08-17/ Time is of the utmost importance to almost any performance test, but, in .net, it can require a bit of scaffolding code. A triplet of C# classes can make short work of measuring performance, and of collating and persisting the results, in a handy XML format. In the wild, this ... http://dev.forrestcroce.com/a-debug-stopwatch-in-c/2009-02-07/ Relative paths look like /images/filename.jpeg, explaining the relationship between the current location and the resource.  Fully qualified paths are complete addresses, and look like http://domain.com/images/filename.jpg. Sometimes you need to translate between the two.  Think of absolute urls as the third normal form of the web. The complete solution has 138 lines in ... http://dev.forrestcroce.com/normalizer-of-web-pages-qualifier-of-urls/2008-12-09/ Another blog devoted to research and development in the software world;  there have been worse ideas, but there have been better ones, too... The open source will come slowly, but do innovative and very useful things.  General ideas, findings, and snippets of code will also find their way to these pages.  ... http://dev.forrestcroce.com/hello-world/2008-11-30/