Develop Course On MSSQL Server Management

Suggestions
1

MSSQL can be a difficult system to manage. Create a course on MS SQL server management including:

  • Installation of SQL Server (non-express)
  • Create databases
  • User management
    • Windows (AD) Auth
      • Granular permissions via AD groups
    • SQL Server auth
  • SQL server backup
    • Simple vs Full strategy
    • Differential vs transaction log