Administering Microsoft SQL Server


Categories: , Tags: ,



  • Plan installation
  • Install SQL Server and related services
  • Implement a migration strategy
  • Configure additional SQL Server components
  • Manage SQL Server Agent
  • Manage and configure databases
  • Configure SQL Server instances
  • Implement a SQL Server clustered instance
  • Manage SQL Server instances
  • Identify and resolve concurrency problems
  • Collect and analyze troubleshooting data
  • Audit SQL Server instances
  • Configure and maintain a back-up strategy
  • Restore databases
  • Implement and maintain indexes
  • Import and export data
  • Manage logins and server roles
  • Manage database security
  • Manage users and database roles