| |
The book is a nuts and bolts guide to creating Windows PowerShell scripts that can be used to administer every aspect of SQL Server. With a very hands-on approach, it guides the reader through the basics of Windows PowerShell, the available Windows PowerShell components that have been integrated into SQL Server 2008, and actual administration tasks. By providing clear, well-structured examples, Microsoft SQL Server 2008 Administration with Windows PowerShell 2.0 shows the reader how to construct effective solutions that can improve the SQL Server administration and monitoring in an enterprise environment. 1. What is Windows PowerShell? 2. Windows PowerShell Command Types, SnapIns, and Cmdlets. 3. Windows PowerShell Programming, Scripting, Error Handling and Debugging. 4. Windows PowerShell Functions, Parameters, Sourcing, Scopes and User Profiles. 5. Working with File System, Registry, and Variables. 6. Working with Event Logs. 7. Working with Windows Services and Processes. 8. Working with WMI. 9. WMI Provider for Configuration Management. 10. WMI Provider for Server Events. 11. Windows PowerShell in SQL Server 2008 Environment, SQL Server PowerShell Provider. 12. Managing Policies through SQLSERVER:. 13. Windows PowerShell and SMO. 14. Building SQL Server Standards and PowerShell Coding Standard. 15. Building SQL Server Inventory. 16. Database Administration and SQL Server Installation. 17. Collecting SQL Server Performance and Host Performance Data. 18. Monitoring SQL Server. 19. Monitoring Disk Space Usage, Database Files and Backups. 20. Defining Policies. 21. Generating Database Scripts.
ISBN : 9788126521913
|
| |
Pages : 576
|