How to Setup and Maintain SQL Server Databases for a DataFlex Developer
When: Thursday, March 8, 2018
Cost: FREE for DISD attendees
Instructors: Chuck Atkinson
A full day of training focused on the essentials for running SQL Server databases at your client sites and in your own development environment. Topics to include:
- Versions of SQL Server
- Installation and configuration
- SQL Clients – installation and versions
- SQL Server Security
- Indices – primary keys, clustered indexes, covering indexes
- Backups and the transaction log
- Recovery model – Full vs. Simple
- Restore
- Restore a client database for troubleshooting
- Activity Monitor
- SQL Log and details of your server
- What is TEMPDB and what is it used for?
- Conversion issues when converting DataFlex embedded
- Client Deployment
- Managing database changes and deployment to your client
Requirements:
- DataFlex 18.2 or later (prefer version 19)
- Download of SQL Server 2014 or later Developer Edition