Spring 2006 Customer Conference
Session: SQL Administration/Nextgen Updates and Patches
User Group: Data Mining
Program Date: Friday, April 21, 2006
Program Hours: 8:30—10:30 a.m.
Location: LMS Training Center, Suite 240
This session is designed to show you the proper setup and maintenance of Microsoft SQL Server in order to manage your Nextgen system. Concepts of using Enterprise Manager, Environment Manager, Query Analyzer, and SQL Service Manager will be covered. You will also learn about the process of applying Nextgen updates to your server and client workstations. This involves full client and thin client configurations and settings as well as updating terminal servers and Citrix Metaframe servers.
In this seminar, you will learn...
How to set up and use Microsoft SQL Server to the fullest, and optimize your SQL server for best performance
The importance of proper procedures when applying Nextgen updates on servers and workstations
How to add new environments as well as add and remove thin client directories per environment
Procedures on running necessary SQL scripts as part of your Nextgen update process and tips on keeping your custom Crystal report forms organized
And much more!
Review and discuss recommended minimum MS SQL maintenance procedures
Create a basic MS SQL maintenance plan
Learn how to review and correct file system and database fragmentation
Review important performance counters
Take a detailed look at other important programs and utilities working behind the scenes, such as Plex Dispatch Service Manager, Computer Management, and Terminal Services Manager
The update procedure
Know the importance of preparing your system for a Nextgen update and what you can do specifically to be ready every time
Learn about when and where to download Nextgen updates, and after applying the update, how file, folder, and database changes affect your system
Discover the value of ini file settings and how this is associated with proper window size, panel size, and grid column arrangement
Environments and thin client configuration
Learn how you can create multiple environments for running Nextgen with live data versus practice data
See how you can easily and dynamically add and remove thin client directories for any environment you create
Running SQL scripts and updating forms
Learn more about running SQL scripts with your Nextgen update and how to read output messages after scripts are completed
How to properly update invoice printing, order printing, statement printing, check printing, and other types of Crystal report forms
|
|
|
