01029nam0 22002771i 450 UON0040863420231205104730.33120120420d1965 |0itac50 baengUS|||| |||||SarkhanWilliam J. Lederer and Eugene BurdickNew YorkToronto ; LondonMcGraw-Hill Book Companycc1965X, 307 p.22 cm.USNew YorkUONL000050CATorontoUONL000778GBLondonUONL003044LEDERERWilliam J.UONV209277708518BURDICKEugeneUONV209278444116McGraw-Hill Book CompanyUONV248683650ITSOL20240220RICASIBA - SISTEMA BIBLIOTECARIO DI ATENEOUONSIUON00408634SIBA - SISTEMA BIBLIOTECARIO DI ATENEOSI III STORIAVAR B 0056 SI MR 82006 5 0056 BuonoSarkhan1525251UNIOR05741nam 2200757Ia 450 991097519390332120260227174643.09786612122613978111805867111180586749781282122611128212261497804705300160470530014(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(OCoLC)741364940(OCoLC)ocn741364940(EXLCZ)99100000000076753320090327d2009 uy 0engurunu|||||txtccrProfessional SQL server 2008 administration with Windows Powershell /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.9780470477281 0470477288 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)Electronic books.lcgftWindows PowerShell (Computer program language)005.2/8254.32bclM A K(Muthusamy Anantha Kumar),1974-1895574Pan Yan1976-1895575MiAaPQMiAaPQMiAaPQBOOK9910975193903321Professional SQL server 2008 administration with Windows Powershell4548545UNINA