Development Articles

DotNetNuke requires that any SQL Script include special additional items to ensure compatibility with the underlying development.

Sometimes when we try to access files we can encounter file locks, or other access exceptions that throw a wrench into the works. I came up with a simple workaround to resolve these issues.

Sometimes you just don't know what you want to query until it comes time to execute the query, this post explores options for creating dynamic where clauses.

Performance is a key pet-peeve of mine, it has to be fast because it can be fast! This post shares some of my favorite DNN Performance Improvement Tips.

Creating a user account via C# code is not exactly straight forward in DNN this post includes a helpful snippet illustrating how to complete this task.

Dynamically attached databases seem incredibly helpful at first glance, however, with anything easy there is always a gotcha, and dynamically attached databases are no different.

Rank, ROW_NUMBER, and Partition are incredibly powerful SQL statements but often misunderstood. This post outlines example usages to illustrate their effectiveness.

Taking proper backups of your DNN based website is critical as if you miss anything you can be left without a working backup.

To fully test your database-driven applications you need test data, it can be tedious to populate, so let us explore a few quick ways to add data.