Microsoft SQL Server 2008 Administration with Windows PowerShell.
General Material Designation
[Book]
First Statement of Responsibility
Ananthakumar Muthusamy
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Hoboken
Name of Publisher, Distributor, etc.
John Wiley & Sons, Inc.
Date of Publication, Distribution, etc.
2011
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
(580 pages)
CONTENTS NOTE
Text of Note
Microsoft Sql Server 2008 Administration with Windows PowerShell; About the Authors; Credits; Acknowledgments; Contents; Introduction; Chapter 1: What Is Windows PowerShell?; Chapter 2: Windows PowerShell Command Types, Snap-ins, and cmdlets; Chapter 3: Windows PowerShell Programming, Scripting, Error Handling, and Debugging; Chapter 4: Windows PowerShell Functions, Parameters, Sourcing, Scopes, and User Profiles; Chapter 5: Working with the File System, Registry, and Variables; Chapter 6: Working with Event Logs; Chapter 7: Working with Windows Services and Processes. Chapter 8: Working with Wmichapter 9: Wmi Provider for Configuration Management; Chapter 10: Wmi Provider for Server Events; Chapter 11: Windows PowerShell in Sql Server 2008 Environment, Sql Server PowerShell Provider; Chapter 12: Managing Policies through Sqlserver: Sqlpolicy; Chapter 13: Windows PowerShell and Smo; Chapter 14: Building Sql Server Standards and PowerShell Coding Standards; Chapter 15: Building Sql Server Inventory; Chapter 16: Sql Server Installation; Chapter 17: Collecting Sql Server Performance and Host Performance Data; Chapter 18: Monitoring Sql Server. Chapter 19: Monitoring Disk Space Usage, Database Files, and BackupsChapter 20: Defining Policies; Chapter 21: Generating Database Scripts; Appendix A: cmdlets; Index.
SUMMARY OR ABSTRACT
Text of Note
The definitive guide to automating SQL Server admnistration with Powershell scriptsIf you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server. You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration.