Microsoft SQL Server 2008 Administration with Windows PowerShell

Name: Microsoft SQL Server 2008 Administration with Windows PowerShell
Price: 8.6 USD
Availability: InStock
ISBN: 9780470477281

ISBN-10: 0470477288

ISBN-13: 9780470477281

Edition: 2009

Authors: Ananthakumar Muthusamy, Yan Pan

List price: $59.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $8.60

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

SQL Server 2008 Administration with Windows PowerShell 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, SQL Server 2008 Administration with Windows PowerShell shows the reader how to construct effective solutions that can improve the SQL Server administration and monitoring in an enterprise environment.Readers who do not have any background in Windows…

Book details

List price: $59.99
Copyright year: 2009
Publisher: John Wiley & Sons, Incorporated
Publication date: 6/9/2009
Binding: Paperback
Pages: 580
Size: 7.50" wide x 9.50" long x 1.50" tall
Weight: 1.892
Language: English



Introduction



What is Windows PowerShell?



Windows PowerShell Command Types, SnapIns, and Cmdlets



Windows PowerShell Programming, Scripting, Error Handling and Debugging



Windows PowerShell Functions, Parameters, Sourcing, Scopes and User Profiles



Working with File System, Registry, and Variables



Working with Event Logs



Working with Windows Services and Processes



Working with WMI



WMI Provider for Configuration Management



WMI Provider for Server Events



Windows PowerShell in SQL Server 2008 Environment, SQL Server PowerShell Provider



Managing Policies through SQLSERVER:\SQLPolicy



Windows PowerShell and SMO



Building SQL Server Standards and PowerShell Coding Standard



Building SQL Server Inventory



Database Administration and SQL Server Installation



Collecting SQL Server Performance and Host Performance Data



Monitoring SQL Server



Monitoring Disk Space Usage, Database Files and Backups



Defining Policies



Generating Database Scripts



cmdlets related to Core Snapins


Index