Kevin Pirnie' Articles

In building my MySQL Store Locator, I figured that it may be a good idea to do the same thing for MS SQL.   Since I have 2012 installed, I built this particularly for that version, and am unsure if it will work in previous versions.  I do know that the Geo datatypes have been severly refined and improved for 2012, so maybe you can keep that in mind when you try this out.Similar situation, I needed something like this built for a 'Store Locator', this time for a .Net site I was building.  I have since decided to add it into my personal webservices which you can see in action here: My Zip Code ServiceAll I'm going to show you is what I did,… Read More
I found myself recently needing to get rid of the Global.asax file.  In building a CDN for myself, having a global.asax file forces cookies to be sent with requests, and for the static content I am serving through my CDN, this is a no-noSo what to do?  I still need to do some page routing for a URL shortening service that is tied directly into this cdn (o7t.in is a shor url =))The answer was pretty much staring me in the face, I just did not realize it, for about 2 days staring at it.   The answer is to use an HTTPModule that imports System.Web, and System.Web.Routing.   Right inside the Init() event is where you would do all your Application_Start stuff!Just make sure to… Read More
Boy oh boy, it's about time we go another one of these "Speed Up The Web" articles out here. As with our last article we showed you how you can develop your ASP.Net website and automatically concatenate your scripts and stylesheets. This article will show you a nice and easy caching mechanism for all your static content. This of course, assumes you do not have use of a CDN (Content Delivery Network). Now, here at o7th Web Design, we have built ourselves a CDN, and for the purposes of this article, we are going to show you how we achieved the caching, and gzipping utilized throughout it. First and foremost, let's get the obvious out of the way first: What Is Caching? What Is GZipping?… Read More
I explained in my earlier post the importance of "warming up" your sites in IIS, especially using the latest .Net frameworks. Here is a major update to the code posted in that post. This one will allow you to "warm up" every site in IIS on your server. All you have to do is set the version of IIS to 7 or 6 depending on your install, and then run the program. You could also set the allApplications flag to false and put in the selected sites to "warm up". Please understand, because of the access needed to warm up all of your sites, this program needs to run under an Administrator account. (it accesses IIS's metabase files) So, without too much blab, and without… Read More
.Net 3.5 Brought to developers of MVC applications the wonderful world of Page Routing. This allows us .Net developers to not have to worry about SEO friendly URLs (pretty much) any more, as we can simplify the URL rewritting process and get rid of those pesky 3rd party add-ons. .Net 4 brings this Page Routing to web forms. Which allows the same thing, however, now we do not have to be developing an MVC application in order for it to be utilized. Yes, there is a little extra code that is necessary to make this all work, however it is well worth the 4-5 lines, of code you can control, over the 3rd party reference with which you have no control over the source code.… Read More