Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

Presentation: DNN Database Tips and Tricks

Hotcakes Presents: DNN Database Tips & 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.


Syed Nabeel
helpful blog, thanks
Syed Nabeel Friday, January 09, 2015 4:25 PM (link)

Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (269)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?