Session Description

A summary and quick how-to of the various admin features in MS SQL Server. Topics include: SQL Management Studio, sandbox database creation, backup and maintenance plans, and disaster recovery planning. Other topics may include: security, importing/exporting, 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.