Microsoft SQL Server 2008 Administration with Windows PowerShell -- About the Authors -- Credits -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- Chapter 1: What Is Windows PowerShell? -- Command-Line Interfaces versus Graphical User Interfaces -- Prerequisites for Installing Windows PowerShell 2.0 -- Installing Windows PowerShell -- Launching Windows PowerShell -- Summary -- Chapter 2: Windows PowerShell Command Types, Snap-ins, and cmdlets -- PowerShell Command Types -- PowerShell Snap-ins -- PowerShell cmdlet Syntax -- Getting Help -- Sorting -- Formatting -- Summary -- Chapter 3: Windows PowerShell Programming, Scripting, Error Handling, and Debugging -- PowerShell Scripts -- PowerShell Variables -- Arrays -- Expressions -- Conditional Expressions -- Loop Construct -- Input -- PowerShell Scripting -- Text File As Input -- Output -- Error Handling -- Debugging -- Summary -- Chapter 4: Windows PowerShell Functions, Parameters, Sourcing, Scopes, and User Profiles -- Functions -- Script Parameters -- Sourcing -- Variable Scope -- Transcripts -- Summary -- Chapter 5: Working with the File System, Registry, and Variables -- Using Get-PSDrive and Get-PSProvider -- Working with File System -- Working with the Registry -- Working with Variables -- Working with Environment Variables -- Summary -- Chapter 6: Working with Event Logs -- Event Log Service -- Event Viewer -- Event Logs -- Log Entry Types -- Exporting the event logs -- Summary -- Chapter 7: Working with Windows Services and Processes -- What Is a Windows Service? -- Windows PowerShell and Windows Services -- Working with Windows Processes -- Get-Process -- Stop-Process -- Summary -- Chapter 8: Working with WMI -- Permission Issues and WMI.

The WMI Model -- Working with Event Log -- Working with Services -- Working with Processes -- Working with Environment Variables -- Working with the Registry -- Summary -- Chapter 9: WMI Provider for Configuration Management -- Managing SQL Server Services -- Managing Client Network Protocols -- Managing SQL Server Client Aliases -- Managing Server Network Protocols -- Changing FILESTREAM Settings -- Changing SQL Server Advanced Properties -- Summary -- Chapter 10: WMI Provider for Server Events -- WMI Provider for Server Events -- WMI Query Language (WQL) -- Event Handling with Windows PowerShell 2.0 -- Monitoring Errors from the SQL Server Error Log -- Monitoring Deadlocks -- Monitoring Blockings -- Monitoring Login Changes and Failed Login Attempts -- Monitoring Databases -- Monitoring Database Objects -- Summary -- Chapter 11: Windows PowerShell in SQL Server 2008 Environment, SQL Server PowerShell Provider -- sqlps Utility -- SQLSERVER: Drive and Invoke-Sqlcmd cmdlet -- SQL Snap-ins -- Encoding and Decoding Uniform Resource Name (URN) -- Summary -- Chapter 12: Managing Policies through SQLSERVER:\SQLPolicy -- SQLSERVER:\SQLPolicy Folder -- Conditions -- Policies -- Summary -- Chapter 13: Windows PowerShell and SMO -- PowerShell and the SQLConnection .NET Class -- Working with SQL Server using SMO -- Working with Databases using SMO -- Working with Tables using SMO -- Backup and Restore with SMO -- Summary -- Chapter 14: Building SQL Server Standards and PowerShell Coding Standards -- SQL Server Standards -- SQL Server Development Standards -- Stored Procedure Standards -- Database Design Standards and Best Practices -- Data Protection Standards and Best Practices -- SQL Server Production Standards -- PowerShell Coding Standard -- Summary -- Chapter 15: Building SQL Server Inventory -- SQL Server Inventory -- Hosts -- Clusters -- ClusterNodes.

Servers -- Databases -- Supplementary Tables -- Summary -- Chapter 16: SQL Server Installation -- Installation Procedure and Template -- Standalone Installation Example -- Cluster Installation Example -- Summary -- Chapter 17: Collecting SQL Server Performance and Host Performance Data -- SQL Server Performance Data Collection -- SQL Server Host Performance Data Collection -- Summary -- Chapter 18: Monitoring SQL Server -- Pinging SQL Server Hosts -- Checking SQL Server-related Services on SQL Server Hosts -- Checking Uptime of SQL Server Hosts -- Monitoring Windows Event Logs -- Monitoring SQL Server Error Log -- Monitoring Blockings -- Monitoring Deadlocks -- Summary -- Chapter 19: Monitoring Disk Space Usage, Database Files, and Backups -- Monitoring Disk Space Usage -- Monitoring Database Files -- Monitoring Backups -- Summary -- Chapter 20: Defining Policies -- Stored Procedure Naming Convention Policy -- Auto_Close and Auto_Shrink Off Policy -- Summary -- Chapter 21: Generating Database Scripts -- Scripting Databases -- Scripting Schemas -- Scripting User-Defined Data Types -- Scripting Tables -- Scripting User Views -- Scripting Stored Procedures -- Scripting XML Schemas -- Scripting Users -- Summary -- Appendix A: cmdlets -- cmdlets Related to Core Snap-ins -- cmdlets Related to the PowerShell Management Snap-in -- cmdlets Related to the Security Snap-in -- cmdlets Related to the Utility Snap-in -- Index.