Entries for July 2007

I have just released a new version of the SQL Formatter/Colorizer utility.  This release is used to resolve issues caused by changes to the parent web service used for formatting!  You may download it for free from the "Software" section of this site.

Comments (0)

Recently there have been numerous discussions on the DotNetNuke.com Forums regarding hosting providers and who one should go with and who they should switch to because they are unhappy with their current provider. During all of these discussions I have always recommended the company that I use for hosting 3Essentials. Since making this recommendation I have been receiving numerous e-mails regarding the process to actually migrate a live site over to 3Essentials so I thought I would write a short blog article that explains the basics of moving a website over to 3Essentials, in actuality these instructions SHOULD work for most providers, however ther might be some differences.

Read more...

Comments (13)

A common problem that I have recently encountered was trying to identify areas of my website database that were taking up the most physical storage space. At work I maintain a DotNetNuke installation that includes a 4.5 Gb reporting database and I was trying to pinpoint the exact sizes of ALL tables in my database and was having a few problems. I started using the "sp_spaceused" stored procedure but I had to run that for every table, I have over 200 tables in this database and it was just not feasiable for me to do it this way. Therefore I wrote a stored procedure that will perform all needed data calls and will return a result set with the data on all tables. In this post I will share the script as well as a few interesting things I learned while writing it.

Read more...

Comments (76)

Due to popular request this article is an updated version of my DNN upgrade process.  Below I will walk you through all steps necessary to upgrade your DNN website from a previous 4.x version to the most current version 4.5.5.  This article is the third revision of my upgrade process documents and has been enhanced with user recommended tips as well as includes new recommendations from my experiences installing new versionf of DotNetNuke.

Read more...

Comments (22)

Installing DotNetNuke can be somewhat difficult at times, therefore I am writing this article to give you a full step by step guide to installing DotNetNuke on a Windows XP Pro system. The instructions are similar for Windows 2000 and XP Home but might vary slightly, I have tried to note as many differences as possible. Windows Vista installation is similar but requires a few different steps relating to IIS.  This article is a re-visit to my first article of this type geared towards DotNetNuke 4.4.1..

Read more...

Comments (116)

DotNetNuke introduced a request filter option starting with DotNetNuke 4.5.3 that can allow you to take action on a user based on various request parameters. In this article I will walk you through how to setup the request filter to filter out requests from a specific IP address and will discuss in general what the settings are. In this example we will be placing a filter to block all traffic from a user with an IP of 13.12.15.45 and we will redirect them to google.com.

Read more...

Comments (41)