Some of the standard questions about a DotNetNuke site are often answered with a T-SQL Query:  Why is my database so big?  What table is the largest? How do you get a list of user’s properties?  How many visitors came to my site yesterday? 

This session will focus on the various T-SQL commands that can help improve the day-to-day functionality of a DotNetNuke site.  Using standard and free modules, the session will demonstrate helpful T-SQL queries that will answer common operational questions.

Updating your site and wanting to determine what 3rd party modules are located on what pages?  This session will help you develop reports to ensure your upgrades deliver few surprises.

The session will also help the attendees understand some of the standard data relationships in a DotNetNuke database so that they can use the tools and techniques discussed to develop T-SQL queries of their own. 

The session will focus on the DotNetNuke V5 database structures. However, the majority of the techniques demonstrated can be used on previous versions of DotNetNuke.