Welcome to issue 32 of DNN Creative Magazine.
This is a very special issue dedicated to improving the efficiency of your administration time with DotNetNuke.
In particular 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 DotNetNuke 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. To begin with we provide a quick start guide to using SQL queries with SQL Server Express. We demonstrate 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 DotNetNuke 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.
This issue comes complete with 11 video tutorials.