Pro PowerShell for database developers. ([2015])

• Record Type: Book
• Further Information: Note: Brian Cafferky.
• Authors: Cafferky, Bryan
• Contents: At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: PowerShell Basics; What Is PowerShell?; Why Is PowerShell Important?; History of PowerShell Versions; Starting PowerShell; The Command Line Interface (CLI); The Integrated Scripting Environment (ISE) ; Enabling Scripting; Using the Integrated Scripting Environment; Encountering Script Errors; Summary; Chapter 2: The PowerShell Language; Challenges to Learning PowerShell; Thinking Differently; Just Got to Get the Job Done; Getting Good Examples. The Paradox of Power The PowerShell Language; A Brief Introduction Using a Script; Operators and Operands; Cmdlets; Variables; Cmdlet Output; Strings; Basic Strings; Here Strings; String Manipulation; Regular Expressions; Editing Strings Using Regular Expressions; Files; Control Flow; If/Elseif/Else; Switch; For Loop; For Each; While; Script Blocks; Arrays; Associative Arrays; Summary; Chapter 3: Advanced Programming; Passing Parameters; Functions; It's All about Objects; A Real-World Use of PowerShell Objects for ETL; Remember the Pipeline. Pipelining Example: SQL Server Deployment Formatting Output; Creating and Using COM Objects; Creating and Using .Net Objects; Waiting for a File; Summary; Chapter 4: Writing Scripts; Strict Mode ; Error Handling ; Using the Try/Catch Block; The Trap Statement; Using Try/Catch and the Trap Statement Together; Setting the ErrorActionPreference Preference Variable; Using the Error Variable and the ErrorAction Parameter; More on the Error Variable; Common cmdlet Parameters ; Debugging; Events and Script Blocks: The Perfect Marriage; Using Windows Events. Using . NET Object Events Using PowerShell Transactions; Conceptual Overview; An Example of How Transactions Should Work; Why Doesn't It Work?; Setting the Integrated Script Editor (ISE) Options; Summary; Chapter 5: Writing Reusable Code; CmdletBinding Arguments ; SupportsShouldProcess ; HelpURI ; SupportsPaging ; Validating Parameters; Validating a String ; Validating a Number ; Validating an Array ; Using the ValidateScript Attribute ; Default Parameter Values; Specifying a Default Parameter Value; Using PSDefaultParameterValues ; Code Using PSDefaultParameterValues. Default Parameter Values When No Default Is Specified Distinguishing Parameter Default Values from Intended Values ; String Parameters ; Numeric Parameters ; Boolean Parameters ; Array Parameters ; Validating Parameters the Old-Fashioned Way; Using Parameter Sets ; Using Switch Parameters with Parameter Sets; ValueFromPipeline and ValueFromPipelineByPropertyName Attributes ; Internationalization with the Data Section ; Summary; Chapter 6: Extending PowerShell; The Four Types of Modules; Script Modules; A Warning about Variable Scopes; Using a Module Like an Object.
• Publisher Details: New York, NY : Apress
• Publication Date: 2015
• Extent: 1 online resource (xxiii, 407 pages)
• Subjects: 005.4/46; Computer science; Windows PowerShell (Computer program language); Web services; COMPUTERS -- Programming Languages -- General; Web services; Windows PowerShell (Computer program language); Computer Science; Database Management; Programming Techniques; Computers -- Programming -- General; Computer programming / software development; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484205419; 1484205413
• Related ISBNs: 9781484205426; 1484205421
• Notes: Note: Vendor-supplied metadata.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.