Venue Sponsor:  | Food & Beverage Sponsor:  |
IMPORTANT! Please register for this event at CodeZone so that we may correctly determine how much food and drinks to provide. This obviously does not include our virtual attendees.
If you do not register, there will not be enough food and beverages to provide for everyone.
Click here to register: https://www.usergroupsupportservices.com/UGEventView.ugss?EventID=8333
This meeting will be broadcast live on the Internet! There will be an ODUG Social for everyone to get together and network following the meeting. See our venue page for the location details.
Topic - SQL Tips and Tricks for DotNetNuke Site Administration
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 presentation 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 presentation 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 presentation will focus on the DotNetNuke V5 database structures including the new audit fields added in V5. However, the majority of the techniques demonstrated can be used on previous versions of DotNetNuke.
About Our Speaker
Paul Scarlett is a DotNetNuke Developer and Evangelist located just to the east Toronto, Ontario and has been working with DotNetNuke since April of 2004 starting with version 2.0. Paul has developed several modules for DotNetNuke that allow ad-hoc access to the external databases and/or the underlying DotNetNuke database. He has presented at User Groups, Code Camps and at DevTeach, a Canadian Developer’s Conference, on his favor topic – DotNetNuke. Paul also presented at 2009’s Day of DNN.