Professional SQL server 2008 administration with Windows Powershell [[electronic resource] /] / Muthusamy Anantha Kumar, Yan Pan

• Autore: M A K (Muthusamy Anantha Kumar), <1974->
• Pubblicazione: Indianapolis, IN, : Wiley Pub., 2009
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (580 p.)
• Disciplina: 005.2/82
• Soggetto topico: Windows PowerShell (Computer program language)
• Classificazione: 54.32
• Altri autori: PanYan <1976->
• Note generali: Includes index.
• Nota di contenuto: 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
• Sommario/riassunto: 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
• Altri titoli varianti: Microsoft SQL server 2008 administration with Windows Powershell
• Titolo autorizzato: Professional SQL server 2008 administration with Windows Powershell
• ISBN: 1-118-05867-4; 1-282-12261-4; 9786612122613; 0-470-53001-4
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910777931903321
• Lo trovi qui: Univ. Federico II