Summary
In this chapter, you learned about the SAU methodology for technology deployment: Standardize configuration settings and implementation procedures. Automate as much administration and maintenance as possible. Update the solution for durability and security. Standardize, automate, and update is SAU.
Next, you learned about several SQL Server features that can help you with the automation process. You learned about jobs and how to create T-SQL, SSIS, and Windows command-based jobs. Then you learned about operators and how to create and use them. Finally, you learned how alerts work and how to create them in both SSMS and the Performance Monitor. These skills will help you develop a fully standardized, automated, and updateable environment. ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
