Training

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: