Professional SQL server 2008 administration with Windows Powershell
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 currentl...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
2009.
|
| Edición: | 1st edition |
| Colección: | Wrox guides Professional SQL server 2008 administration with Windows PowerShell
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627317406719 |
Tabla de Contenidos:
- 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
