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 ( 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
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice to be able to simply plug it in and go, unfortunately this is not the case, and there is some configuring to do. Please see here: Now, this article is not about the IIS extension, this is about priming or warming up your site. Now, this is not a necessity, but if you are like me, you take advantage of .Net's Runtime.Caching, so simply priming your App Pools may not be enough. My SRE (Site Rendering Engine) for one… Read More