Find a post...

DNN-Connect Blogs

Presentation: DNN Database Tips and Tricks

If you’re reading my blog post for the first time, you may not know that I’ve been working with DNN nearly since it was released.  That’s well over 10 years of managing DNN sites of various sizes, purposes, and deployments.  This experience has ranged from businesses that run on the platform, to running subsets of an organizations web properties on it, and more.  During my consulting days, I saw all kinds of DNN sites.  This wide range of challenges has resulted in learning a large number of things – including how to leverage SQL Server to solve problems in a creative way.  That’s what this session was about.

One could spend all day long discussion this topic, but I only had about an hour.  So, I chose the following topics in this area:

  • Clear Space – How to reduce the amount of space that some tables take up in your database.
  • Change DBO Role Owner – Sometimes, you can’t use a desired username in your database because it is the same as where it came from.
  • Change or Replace Themes – There are cases when you need to either fix skin assignments from administrators, or roll out a new theme.
  • Database Object Sizes – Running a query to determine what database objects are too large.
  • Take Over a Site Locally – Automating the task of preparing an inherited site to be used in support or development environments.

We also had time to delve into another topic…  Wiping out the entire database using SQL scripts, instead of deleting the database and creating a new one.  This has come in handy for me when managing a DNN site in shared hosting environments on multiple occasions.

David Poindexter recorded the meeting, so keep an eye on the @QCDUG twitter account if you want to watch it.  I am sure they’ll make an announcement when it’s ready.  In the meantime, the slide deck and SQL scripts we went over a linked below.  Enjoy!

Download the Presentation

Download the SQL Scripts

This blog entry is cross-posted from my personal blog site.

Will Strohl is an author and technologist in the San Francisco area, specializing in DNN. During his career, Will has held positions ranging from Help Desk Technician to being the Director of Technology and is a former employee of DNN Corp., having run the evangelical, sales engineering, and education programs. Today, Will is the the Director of Product Management at a very exciting e-commerce software company, Hotcakes Commerce (

Hosting liberally provided by

Philipp Becker 6019 7
Geoff Barlow 550 4
DNN-Connect 431 6
Peter Donker 5107 30
Christopher Hammond 689 2
Olivier Jooris 421 1
Daniel Mettler 12053 88
Clint Patterson 1 1
Jos Richters 65 1
James Rosewell 327 2
Will Strohl 1548 27
Ernst Peter Tamminga 438 4
Barry Waluszko 2860 2
Declan Ward 503 1
Gifford Watkins 724 9
Torsten Weggen 2774 3