Professional SQL server 2008 administration with Windows Powershell / Muthusamy Anantha Kumar, Yan Pan.

Format:

Book

Author/Creator:

M A K (Muthusamy Anantha Kumar), 1974-

Contributor:

Pan, Yan, 1976-

Series:

Wrox guides Professional SQL server 2008 administration with Windows PowerShell

Language:

English

Subjects (All):

SQL server.

Windows PowerShell (Computer program language).

Genre:

Electronic books.

Physical Description:

1 online resource (580 p.)

Edition:

1st edition

Other Title:

Microsoft SQL server 2008 administration with Windows Powershell

Place of Publication:

Indianapolis, IN : Wiley Pub., 2009.

Language Note:

English

System Details:

text file

Summary:

The definitive guide to automating SQL Server administration 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 ad

Contents:

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 WMIThe 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

Notes:

Includes index.

ISBN:

9786612122613

9781118058671

1118058674

9781282122611

1282122614

9780470530016

0470530014

OCLC:

428440006