用WindowsPowerShell管理SqlServer2008PDF版资源-CSDN文库

4星 · 超过85%的资源需积分: 10 185 浏览量 2009-08-24 11:30:44 上传评论收藏 8.7MB PDF 举报

资源推荐

资源详情

资源评论

Microsoft

SQL Server

2008 Administration

with Windows PowerShell

™

www.wrox.com

$59.99 USA

$71.99 CAN

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers

for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

Recommended

Computer Book

Categories

Database Management

General

ISBN: 978-0-470-47728-1

Arul Kumaravel, Jon White, Naixin Li, Scott Happell, Guohui Xie, Krishna C. Vutukuri

Updates, source code, and Wrox technical support at www.wrox.com

Wrox Programmer to Programmer

Professional

Windows

PowerShell

™

Programming:

Snap-ins, Cmdlets, Hosts, and Providers

Secure, reliable, and scalable, SQL Server 2008 delivers a dynamic, smart, and

productive data platform for all your data-related needs and offers many new

features that will change how you administer a database server. Among these

new features is the ability to use Windows PowerShell 2.0 scripts to automate and

manage various aspects of the Windows environment.

Written by well-known and highly respected SQL Server experts, this nuts-and-

bolts guide brings together the best of both worlds—database and system

administration—to help you manage, automate, and control your environment.

You’ll discover how to construct effective and practical solutions that can improve

SQL Server administration and monitoring while saving you countless hours of

manual effort and ensuring more consistent results.

Packed with clear, well-constructed examples throughout, this tutorial-based

resource covers the fundamentals of Windows PowerShell so you can get started

writing scripts in Windows PowerShell to perform SQL Server 2008 administration

tasks immediately.

What you will learn from this book

● How Windows Management Instrumentation Providers for SQL Server enable

you to manage SQL Server services and network connectivity

● How to manage SQL Server objects, including the new policy objects using the

new SQL Server 2008 support for Windows PowerShell

● Ways to use SQL Server Management Objects to create database and

database objects, and backup and restore databases

● Techniques for building an SQL Server inventory over an existing or new

environment

● Tips for installing, monitoring, collecting performance data, database scripting,

and more, using Windows PowerShell

● Various programming features such as inputs, outputs, debugging, functions, and more.

Who this book is for

This book is for SQL Server database administrators, developers, or system administrators who are looking to manage SQL Server

2008 using Windows PowerShell 2.0. No previous Windows PowerShell experience is assumed.

Enhance Your Knowledge

Advance Your Career

Microsoft

SQL Server

2008 Administration

with Windows PowerShell

™

MAK

Yan Pan

spine=1.152"

Updates, source code, and Wrox technical support at www.wrox.com

Microsoft

SQL Server

2008

Administration

with Windows PowerShell

™

Ananthakumar Muthusamy, Yan Pan

Wrox Programmer to Programmer

Arul Kumaravel, Jon White, Naixin Li, Scott Happell, Guohui Xie, Krishna C. Vutukuri

Updates, source code, and Wrox technical support at www.wrox.com

Wr ox Prog ram mer to Prog ram mer

Professional

Windows

PowerShell

™

Programming:

Snap-ins, Cmdlets, Hosts, and Providers

Enhance Your Knowledge

Advance Your Career

Professional SQL Server 2008 Administration

ISBN 978-0-470-24796-9

This book is intended for developers, DBAs, and casual users

who hope to administer or may already be administering a SQL

Server 2008 system and its business intelligence features,

such as Integration Services. This book is a professional book,

meaning the authors assume that you know the basics about

how to query an SQL Server and have some rudimentary

concepts of SQL Server already. For example, this book does

not show you how to create a database or walk you through the

installation of SQL Server using the wizard. Instead, the author of

the installation chapter may provide insight into how to use some

of the more advanced concepts of the installation. Although this

book does not cover how to query an SQL Server database, it

does cover how to tune the queries you’ve already written.

Microsoft SQL Server 2008 Administration

with Windows PowerShell

ISBN 978-0-470-47728-1

If you’re an 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.

Professional Windows PowerShell Programming:

Snapins, Cmdlets, Hosts and Providers

ISBN 978-0-470-17393-0

Providing you with the programmer’s approach to understanding

Windows PowerShell, this book introduces the concepts,

components, and development techniques for building software

packages that leverage the power of PowerShell.

Beginning Microsoft SQL Server 2008 Administration

ISBN 978-0-470-44091-9

This book teaches you how to develop the skills required to successfully administer an SQL Server 2008 database; no prior

experience is required. The material covers system installation and configuration/architecting, implementing and monitoring

security controls, configuring and managing network communications, automating administration tasks, disaster prevention

and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components

including Integration Services, Reporting Services, Analysis Services, and Service Broker.

Microsoft

SQL Server

2008 Administration

with Windows PowerShell

™

Get more out of

WROX.com

Programmer to Programmer

™

Interact

Take an active role online by participating in

our P2P forums

Wrox Online Library

Hundreds of our books are available online

through Books24x7.com

Wrox Blox

Download short informational pieces and

code to keep you up to date and out of

trouble!

Chapters on Demand

Purchase individual book chapters in pdf

format

Join the Community

newsletter.wrox.com

Browse

Ready for more Wrox? We have books and

e-books available on .NET, SQL Server, Java,

XML, Visual Basic, C#/ C++, and much more!

We always like to get feedback from our readers. Have a book idea?

Need community support? Let us know by e-mailing wrox-partnerwithus@wrox.com

spine=1.152"

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 Proﬁles .... . . . . . .... . . . . . . . .... . . . . . . . .... . . . 77

Chapter 5: Working with the File System, Registry, and Variables .. . . .... . . . 93

Chapter 6: Working with Event Logs .. . . . . . ..... . . . . . . . .... . . . . . ...... . . . . 123

Chapter 7: Working with Windows Services and Processes . . . . . . ...... . . . . 141

Chapter 8: Working with WMI .. . . . . . . . .... . . . . . ...... . . . . . .... . . . . . . . .... 159

Chapter 9: WMI Provider for Conﬁguration Management.. .... . . . . . . . .... . . 197

Chapter 10: WMI Provider for Server Events .. . . . . . .... . . . . . . . ..... . . . . .... 219

Chapter 11: Windows PowerShell in SQL Server 2008 Environment,

SQLServerPowerShellProvider ..............................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: Deﬁning Policies. . . .... . . . . . . . ..... . . . . ....... . . . . . .... . . . . . . 475

Chapter 21: Generating Database Scripts .. . . . . . .... . . . . . . . .... . . . . . ...... 487

Appendix A: cmdlets .. . . ..... . . . . ....... . . . . . .... . . . . . . . .... . . . . . . . .... . . 507

Index ... . . . . . . . ..... . . . . ....... . . . . . .... . . . . . . . .... . . . . . . . .... . . . . . ...... 531

剩余579页未读，继续阅读

评论收藏

内容反馈

liu867090869

2014-04-04

英文的看起来有点吃力，不过赞一下
爱吃菠萝的程序员

2015-04-29

power shell 功能强大，希望能找到办法解决我面临的Sql server的难题
imqqmsn

2012-08-09

如题，不过是英文的

xuwedo2003

粉丝: 31
资源: 196

用Windows PowerShell管理Sql Server 2008 PDF版

最新资源

用Windows PowerShell管理Sql Server 2008 PDF版

PowerShell for SQL Server Essentials.pdf

《精通windows powershell 脚本编程》脚本资源安装文件

精通Windows PowerShell 脚本编程 的配套脚本资源

Windows_PowerShell脚本编程

精通Windows+Server+2008命令行与PowerShell.zip-3

精通Windows+Server+2008命令行与PowerShell.zip-5

精通Windows+Server+2008命令行与PowerShell.zip-6

精通Windows+Server+2008命令行与PowerShell.zip-1

精通Windows+Server+2008命令行与PowerShell.zip-2

WindowsXP-KB926140-v5-x86-CHS.rar Windows PowerShell 安装SQL Server 2008必备组件

SQL Server 2008管理员必备指南(超高清PDF)Part1

SQL Server 2008管理员必备指南(超高清PDF)Part2

windows自带powershell 连接mssql sqlserver

精通Windows+Server+2008命令行与PowerShell.zip-4

精通Windows+Server+2008命令行与PowerShell.zip-7

精通Windows+Server+2008命令行与PowerShell.zip-8

PowerShell管理Win Server 2008 R2

SQL Server 2008管理员必备指南(超高清PDF)Part3

SQL.Server.2008管理员必备指南.part2.rar（2/4）

Windows PowerShell

Microsoft SQL Server 2008 Management and Administration(经典).pdf

SQL.Server.2008管理员必备指南.part1.rar（1/4）

Wrox - Professional Windows PowerShell for Exchange Server 2007 SP1 (Jan 2008)

Sql Server 2008 R2 资源控制器管理

Windows PowerShell 1.0

Windows PowerShell 1.0 xp x86(32位) KB926139 ENU

Windows Server 2008 将与 Visual Studio 2008 以及 SQL Server 2008 共同发布

SQL.Server.2008管理员必备指南.part4.rar（4/4）

最新资源

精通Windows PowerShell 脚本编程的配套脚本资源