05549nam 2200673Ia 450 991077793190332120200520144314.01-118-05867-41-282-12261-497866121226130-470-53001-4(CKB)1000000000767533(EBL)469032(OCoLC)428440006(SSID)ssj0000228565(PQKBManifestationID)11201981(PQKBTitleCode)TC0000228565(PQKBWorkID)10168087(PQKB)10691315(Au-PeEL)EBL469032(CaPaEBR)ebr10308376(CaONFJC)MIL212261(CaSebORM)9780470477281(MiAaPQ)EBC469032(EXLCZ)99100000000076753320090327d2009 uy 0engurunu|||||txtccrProfessional SQL server 2008 administration with Windows Powershell[electronic resource] /Muthusamy Anantha Kumar, Yan Pan1st editionIndianapolis, IN Wiley Pub.20091 online resource (580 p.)Wrox guides Professional SQL server 2008 administration with Windows PowerShellIncludes index.0-470-47728-8 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 TypesPowerShell 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; SummaryChapter 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 WMIPermission 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.0Monitoring 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 SMOPowerShell and the SQLConnection .NET ClassThe 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 adMicrosoft SQL server 2008 administration with Windows PowershellWindows PowerShell (Computer program language)Windows PowerShell (Computer program language)005.2/8254.32bclM A K(Muthusamy Anantha Kumar),1974-1506923Pan Yan1976-1506924MiAaPQMiAaPQMiAaPQBOOK9910777931903321Professional SQL server 2008 administration with Windows Powershell3737354UNINA