User Group Support Services - User Group Event

Event information
User Group Name:	Orlando DotNetNuke® Users Group (ODUG)
Event Title:	Paul Scarlett - SQL Tips and Tricks for DotNetNuke Site Administration
Event Description:	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.
Event Time:	09 March 2010 19:00 to 09 March 2010 21:00 (GMT-5: Eastern Time US & Canada)
Event Location:	37 North Orange Avenue, Suite 600, Orlando, Florida, 32801, United States
Event URL:	http://orlando.dotnetnukeug.net/WhatsNew/Events/tabid/91/ctl/Details/Mid/428/ItemID/137/Default.aspx
Programming Language Topics:	C#, VB.NET, ASP.NET, HTML, XML, SQL
Technology Area Topics:	Visual Studio 2005 / Visual Studio .NET, .NET Framework, Windows Vista, Web Development, Web Services, SQL Server and Data Access, Windows Server System, Team Development, Source Control and Testing, Enterprise Architecture and Patterns, Security, 64-Bit Development, User Interface and Graphic Design