Learn SQL Queries in DotNetNuke to reduce administration time
Posted by: A DotNetNuke blog for tutorials, tips & tricks,
on 08 May 2008 |
View original | Bookmarked: 0 time(s)
So, its been a busy month on DNN Creative as weve stepped into the realms of SQL Queries.
We've had several enquiries from the readers asking if we know of any ways to speed up the process of updating their DotNetNuke websites without having to change each page one after another.
From our experience of re-skinning and updating already established websites, we found that with simple SQL queries you can quickly and efficiently update multiple elements from modules, pages, and skins to alter the look and layout of your site within seconds which for some large DNN site updates would take months of work through manually administering the site.
If you are new to using SQL Queries and would like to learn more about this powerful administration tool, checkout issue 32 of DNN Creative magazine. The first tutorial is an Introduction to SQL Queries with SQL Server Express, DotNetNuke and Vista.
This tutorial is especially helpful if you are using windows vista, as setting up SQL Server Express isnt as straight forward as you would think. We show you how to install and configure SQL Server, and then start you off with simple queries so you can get well on the way to improving your site.
Heres a quick breakdown of what this tutorial covers:
Video 1 - How to Attach a DotNetNuke Database to SQL Server Express using Windows Vista
Video 2 - How to Create a User Account and set up Permissions
Video 3 - How to Edit the Web.config Connection String
Video 4 - How to Create a SQL Query, How to Connect to a Live Database