11 DotNetNuke Video Tutorials - Powerful Efficient Techniques for DotNetNuke Administration using SQL

DNN Creative have released issue 32 of the DotNetNuke Magazine.

This very special issue of DNN Creative Magazine is dedicated to improving the efficiency of your administration time with DotNetNuke.

In this issue we focus on using SQL queries to automate some of the repetitive tasks that you have to carry out as an administrator on a DotNetNuke portal.

These are very powerful techniques which for large Dot Net Nuke websites can reduce a week of work into seconds.

If you are new to SQL you can follow each of these tutorials through step by step. We provide a quick start guide to using SQL queries with SQL Server Express. We also show you how to set up SQL Server Management Studio Express using Windows Vista so that you can execute a basic query on both a localhost and live DotNetNuke database.

Following this we demonstrate using SQL queries for working with DotNetNuke security roles and users, focusing on exporting registered users to Excel and removing users from a security role based on their email address.

To finish we demonstrate working with shadow / copied modules. This is an essential and powerful administration task that can enhance your DNN portals and reduce administration time. Shadow or Copied modules can be used to update the same content on several pages from one central area. We demonstrate how you can use SQL queries to easily maintain these copied modules.

The SQL techniques outlined in this tutorial are very powerful techniques for easily and quickly manipulating multiple copied modules across thousands of pages in a DotNetNuke portal and are particularly useful if you are re-skinning an already established site.