Professional SQL Server® 2008 Administration with
Windows PowerShell™
Introduction
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Chapter 1: What Is Windows PowerShell? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 2: Windows PowerShell Command Types, Snap-ins, and cmdlets . . . 15
Chapter 3: Windows PowerShell Programming, Scripting, Error Handling,
andDebugging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
Chapter 4: Windows PowerShell Functions, Parameters, Sourcing,
Scopes, and User Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
Chapter 5: Working with the File System, Registry, and Variables . . . . . . . . . . . 93
Chapter 6: Working with Event Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123
Chapter 7: Working withWindows Services and Processes . . . . . . . . . . . . . . . . 141
Chapter 8: Working with WMI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
Chapter 9: WMI Provider for Configuration Management. . . . . . . . . . . . . . . . . . . 197
Chapter 10: WMI Provider for Server Events . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
Chapter 11: Windows PowerShell in SQL Server 2008 Environment,
SQL Server PowerShellProvider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .241
Chapter 12: Managing Policies through SQLSERVER:\SQLPolicy . . . . . . . . . . 259
Chapter 13: Windows PowerShell and SMO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 283
Chapter 14: Building SQL Server Standards and PowerShell Coding
Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 317
Chapter 15: Building SQL Server Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 333
Chapter 16: SQL Server Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377
Chapter 17: Collecting SQL Server Performance and Host Performance
Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .401
Chapter 18: Monitoring SQL Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 419
Chapter 19: Monitoring Disk Space Usage, Database Files, and Backups . . 451
Chapter 20: Defining Policies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
Chapter 21: Generating Database Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487
Appendix
A: cmdlets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . 507
Index . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . 531
