Every once and a while you probably find yourself needing to create an overview of DNN users and some of their profile properties. For instance when your client wants to have that data in an excel spreadsheet….

[Read the rest of this article...]

Just recently i answered a question on the DotNetNuke forums about re installing the Search Results module. This is somewhat tricky as you cannot do it by hand.. it can only be done by sql script

[Read the rest of this article...]

Where it comes to using SQL Server features, I am a very late adopter. Not by choice, for all the DotNetNuke modules I create, I'd like to maintain backwards compatibility as much as possible, especially since DotNetNuke also fully supports MS SQL Server 2000.

[Read the rest of this article...]

Today I had to upgrade an old DNN 3.2.2 multiportal installation to DNN 4.8.1. There are 3 major areas that changed in the past DotNetNuke versions: New contstraints and unique indexes on Files table DNN Membership provider Consolidation of http handlers in one assembly

[Read the rest of this article...]

A lot of posts in the Install It! forum are from people wonder how to move their DNN installation from their development environment to production. In a nutshell, this is the process:

[Read the rest of this article...]

This night, I had to move a complete set of databases (20 in total) from one SQL server to another. In the past that has always taken me quite some time, so this time I set out to try to do this in a more efficient manner.

[Read the rest of this article...]

 DotNetNuke and SQLServer don't always work together in the best of ways, especially if the system culture of the webserver is different from the language setting in sql server. If this is the case, then some modules will have problems saving datetime values to the database. For instance, if the database is expecting German type dates (dd.MM.yyyy), and DNN is sending US type dates (MM/dd/yyyy), in the best case dates will be saved with wrong information (reversed day and month), and in the worst case an error will occur.

[Read the rest of this article...]