Session Description

A summary and quick how-to of the various admin features in MS SQL Server and other vendors. Topics include: SQL Management Studio, security, SSIS and 3rd party transaction tracking software. Other topics include: creating new databases, importing/exporting, backups, maintenance, and error checking, as well as query creation and scripting.

Session Content

• Using SQL Server Management Studio (SSMS) to administer your MS SQL Server Instance
• Creating new databases for testing DML queries, new features, etc.
• Disaster recovery plan
• Database Backup types, plans, etc.
• Maintenance Plans
  • Integrity checks, index maintenance, statistics, and more

Documentation

Associated documentation for this session is attached.