SQL Server guru Brian Knight will save you plenty of time and money in labor, frustration, and SQL Server downtime. This book provides undocumented troubleshooting tips and tricks, and is a quick reference on system administrative functions essential for DBAs. It explains architecture, optimization techniques, automation, management, security, and more.
Ch. 13: Securing SQL Server Ch. 4: Optimizing and Automating SQL Server Administration Ch. 5: Monitoring and Tuning SQL Server Ch. 6: Automating Administrative Tasks Ch. 7: Optimizing and Troubleshooting SQL Server Ch. 8: Optimizing and Troubleshooting T-SQL Ch. 9: Disaster Planning and Recovery Ch. 10: Scaling SQL Server Ch. 11: Clustering Architecture Ch. 12: Step-by-Step Guide to Clustering Ch. 13: SQL Server Replication Appendices Appendix A: System Tables and Undocumented DBCC Commands Appendix B: Documented and Undocumented Extended Stored Procedures Appendix C: DBA Responsibilities Appendix D: Finding the Right DBA - Interview Questions