Committee Education

Hi everyone 

I spoke with Carmen today and she has inquired about more details of what specifically she should or could cover at Meeting of the Minds on Sequel.  

Can you all provide any additional comments, information or details of what you think would be appealing to membership at this time? Thanks!

------------------------------
Anne Sawyer
Executive Director
90 Minds, Inc.
CA
------------------------------

Installing a SQL instance to a drive other than the C drive.  The version of SQL to use such as developer etc.  Steps to take after SQL instance is installed.

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

• Advantages / disadvantages of using the Simple recovery model. 
• Where is the best location in a hard disk array to store transaction logs.
• How to back up and restore databases.
• How to create a maintenance plan.
• How to set up SQL user permissions for Sage 100 Premium (MAS_user and MAS_Reports).
• How to make a copy of a table, and how to copy a table from one database to another database.
• How to create simple queries that are most useful in Sage 100.  For example, how to modify a select statement to use the where clause and other common T-SQL commands.
• Common pitfalls, tips and tricks when migrating and converting SQL / Premium data from one Sage 100 version to a new version.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------