Microsoft SQL Server 2008 Administration with Windows PowerShell

The definitive guide to automating SQL Server admnistration with Powershell scripts

If 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 tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort.

The new release of Microsoft SQL Server 2008 now includes Windows PowerShell, allowing administrators of large-scale enterprise databases to automate many tasks

SQL Server 2008 Administration with Windows PowerShell introduces you to PowerShell, covering its components in detail as well as providing basic instruction in using scripts to administer the database

The book includes numerous examples of SQL tasks that have been automated and also provides completed scripts that you can put to use immediately

The Companion Web site includes complete code scripts

If you're a database administrator, the scripts and techniques in SQL Server 2008 Administration with Windows PowerShell will save you hours of effort.

==> Download <==

Windows PowerShell Pocket Reference: Pocket Reference

Book Description

This portable reference to Windows PowerShell summarizes both the command shell and scripting language, and provides a concise reference to the major tasks that make PowerShell so successful. It's an ideal on-the-job tool for Windows administrators who don't have time to plow through huge books or search online.

Written by Microsoft PowerShell team member Lee Holmes, and excerpted from his Windows PowerShell Cookbook, Windows PowerShell Pocket Reference offers up-to-date coverage of PowerShell's 1.0 release. You'll find information on .NET classes and legacy management tools that you need to manage your system, along with chapters on how to write scripts, manage errors, format output, and much more.

==> Download <==

Windows PowerShell(TM) Scripting Guide

Book Description

Get practical guidance for using Windows PowerShell to manage Windows Vista and Windows Server 2008. Written by Ed Wilson, a leading scripting expert and trainer at Microsoft, this reference offers a task-based approach to help you find the information you need for day-to-day tasks. With more than 200 scripts, it offers rich examples that administrators can customize for their own environment and needs. The scripts range in complexity from one-line commands, to full-blown scripts with managed output and command-line arguments examples that are applicable to all skill levels.

==> Download <==

Professional Windows PowerShell Programming: Snapins, Cmdlets, Hosts and Providers

Book Description

In Wrox's Professional PowerShell Programming, readers are treated to a guided tour of PowerShell from a programmer's perspective as Microsoft PowerShell development team member Arul Kumaravel skillfully guides readers through all the ins and outs of the PowerShell SDK, and shows them how to create extensions to PowerShell and integrate PowerShell capabilities into their own applications. Coverage includes:

* Extending PowerShell Engine with Snapins
* Adapter Implementations
* Developing Cmdlets
* Developing Providers - Drive, item, navigation, container Providers and more
* Hosting PowerShell Engine in applications
* Creating Applications that Use a Custom Host
* Extending Object Types and Formatting
* and more.

==> Download <==

Pro Windows PowerShell

Book Description

Windows power users have always envied their friends running UNIX machines for the ease of automation that they enjoy. The traditional Windows command–line shell, cmd.exe, has never been up to par with shells like bash or tcsh, especially when it comes to text processing and process automation.

Windows PowerShell changes all that. This next–generation shell is also a full–blown scripting environment with a real programming language that allows users to access every part of their operating system. Files, registry entries, and COM and .NET objects are all supported by PowerShell, which makes manipulating them a breeze.

Pro Windows PowerShell will show you how to use all this power in your own work. You’ll discover the object–oriented features of the shell and how they help in extracting and manipulating data. You’ll then learn how to use those features to solve real–world problems: manipulating files, working with text, monitoring systems, and performing operations over the network. The book serves as not only a tutorial, but also a reference: the “Real World” part is structured so that it can be read nonlinearly and used as a reference or a cookbook. And you’ll find freely available tools and extensions that will help you do things even faster.

==> Download <==