Simple Zip Code to Zip Code Distance Calcuations with SQL Server 

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.

Read more...

Posted by Mitchel on Monday, January 23, 2012

DotNetNuke 6.x Text Editor Upgrade Issues 

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.

Read more...

Posted by Mitchel on Sunday, January 22, 2012

Improve Performance with Static File Caching 

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.

Read more...

Posted by Mitchel on Thursday, January 19, 2012

2011 Year in Review and a look at 2012 

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.

Read more...

Posted by Mitchel on Sunday, January 08, 2012

Upgrading MitchelSellers.com - A DotNetNuke Upgrade Retrospective 

For those of you that are regular visitors to this site you most likely noticed a number of changes to the site over the past 24 hours, including a small amount of downtime.  This was caused by changes surrounding the upgrade of this site to DotNetNuke version 6.1.2.  Now, I have worked on a number of DotNetNuke upgrades over the years, and I lost count a few years back at about 300 upgrades.  This site was by-far one of the hardest upgrades that I have ever completed and in this post I will share a bit around the growing pains that were experiences throughout the process.

Read more...

Posted by Mitchel on Friday, January 06, 2012

Getting Up to Speed on DNN 6.x Design 

So like many developers I have been spending some time recently updating my client, commercial, and open-source modules to support the new DotNetNuke 6 Form Pattern from a design perspective, to make my modules better integrate into the system.  Looking around when I was starting there is very little "true" documentation on this concept, and for me it was a bit cumbersome pulling everything together.  I started with this Wiki Article and then ended up spending a lot of time digging/inspecting lots of other modules that had been upgraded.  So in this post, I'm going to take a bit more of a 'code-centric" no-nonsense approach to what your form should really look like, I hope that this helps you.

Read more...

Posted by Mitchel on Monday, December 19, 2011

Understanding and Mitigating DotNetNuke Upgrade Risks 

With all of the recent changes that have come to the DotNetNuke product in the past few years I have been seeing more and more situations where users have older installations that want to get to DNN 6.x to take advantage of the new features that are available with the latest version.  I can't say as I blame them the newest features are great and a true benefit to all that use them, however, the road to getting there isn't always as peachy as it might seem, as you often find people with upgrades that fail horribly.  This has been a common trend and some of the things that DotNetNuke Corporation has done really makes this process less error prone, but a bit portion of the "getting it right" upgrade process really falls in the hands of the site administrators that are going to be doing the upgrades.  That is the focus on this blog post, how can we as site administrators identify potential risks and then mitigate/resolve the issues on our own?

Read more...

Posted by Mitchel on Friday, November 18, 2011

DotNetNuke World 2011 Recap 

As most of you know I was at the DotNetNuke World 2011 event in Orlando Florida this past week, and I thought I would give a quick recap of my experience with the event and share how much different I felt this event was in comparison to the previous DotNetNuke Connections events.  To help try and give proper justice to the topic, I'm going to break my review out in a few different categories to help make it a bit more understandable, and without further delay, here we go!

Read more...

Posted by Mitchel on Sunday, November 13, 2011

Force User Roles Update via DotNetNuke 

One of the things that I have been finding that I do a lot recently is updating user security roles based on actions either taken by the users or actions that have been taken by others.  Doing so is quite simple from a DotNetNuke API perspective but how do you go about actually forcing the role membership change right away?  That is what I'll talk about in this post.

Read more...

Posted by Mitchel on Monday, November 07, 2011

DotNetNuke 6.1.x Release and Warning! 

As I'm sure that you have seen in the last day or so DotNetNuke 6.1.0 was released.  Overall, this release is a major improvement for DotNetNuke with enhancements to performance, support for mobile devices and other general upgrades.  However, I've already been alerted to a major, slightly hidden change that I wanted to be sure to put out here as a warning.

Read more...

Posted by Mitchel on Wednesday, November 02, 2011

Previous Page       1 of 38       Next Page

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion.  The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Friend of RedGate

www.datasprings.com - DotNetNuke ModulesICG

Click here for advertising information.

Content in this blog is copyright protected.  Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided.  Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.