Microsoft SQL Server 2008 R2 Administration Cookbook
上QQ阅读APP看书,第一时间看更新

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