Chapter 2. Administrating the Core Database Engine

In this chapter, we will cover:

  • Designing automated administration practices
  • Implementing Security feature enhancements
  • Implementing Availability feature enhancements
  • Implementing Monitoring and Tuning for performance
  • Administering SQL Server workloads with Resource Governor
  • Designing SQL Server Agent scheduled jobs for ETL processes
  • Troubleshooting multi-server instances with utility administration
  • Administering SQL Server Replication processes
上一章目录下一章