Latest Blog Posts
Simple Zip Code to Zip Code Distance Calcuations with SQL Server by Mitchel Sellers
Over the years I have implemented a number of various "near me" style searches using third-party zip code databases and a long, complicated formula to find the distance between two different latitudes and longitudes. Well, starting with SQL Server 2008, it is possible to get the same result, with a lot less effort, following two simple steps. In this post I will walk through things step by step.
DotNetNuke 6.x Text Editor Upgrade Issues by Mitchel Sellers
In the past 2-3 weeks I have been working on upgrading the DotNetNuke Installations on both this website and the IowaComputerGurus website and finally I can say I'm done with the upgrades. These sites, although not that complex had a number of issues with the upgrades, some of which I have blogged about in the past, and then today a brand new oddity was discovered. After upgrading the site everything was functional, however the text editors were behaving very unusually. Clicking "Save" at times would not redirect you back to the page, but content would be saved. Other times it would redirect you back to the page, but your changes were not saved. I couldn't find any rhyme or reason behind it, so I started digging.
Improve Performance with Static File Caching by Mitchel Sellers
This post will be the first of what will be many posts with regards to application performance. After giving a number of presentations over the last 1-2 years, including one this evening in the Minneapolis/St. Paul area I've decided that some of these tips/tricks that I have with regards to improving application performance should really get put out here so people can find them and make the improvements to their applications. Going forward all of these posts will be categorized with at least the "Performance" category and then others that identify what systems are benefited by the changes. The subject of this post is Static Content Caching.
2011 Year in Review and a look at 2012 by Mitchel Sellers
Over the last few years I have been trying to keep a little bit better track of usage of the content here on MitchelSellers.com as well as just keeping track of other interactions that I have through User Groups, Open Source Projects, and the like. Each year around the end of the year I try to compile a few of these items, if not for everyone that is reading things here for myself to see how things progress year to year.