Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro PowerShell for Database Developers

  • Book
  • © 2015

Overview

Authors:
  1. Bryan Cafferky
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Shell for Database Developers is a deep dive into professional application development using Windows Power.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 69.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 89.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xxiii
    Download chapter PDF

  2. PowerShell Basics

    • Bryan Cafferky
    Pages 1-17

  3. The PowerShell Language

    • Bryan Cafferky
    Pages 19-42

  4. Advanced Programming

    • Bryan Cafferky
    Pages 43-74

  5. Writing Scripts

    • Bryan Cafferky
    Pages 75-109

  6. Writing Reusable Code

    • Bryan Cafferky
    Pages 111-143

  7. Extending PowerShell

    • Bryan Cafferky
    Pages 145-171

  8. Accessing SQL Server

    • Bryan Cafferky
    Pages 173-202

  9. Customizing the PowerShell Environment

    • Bryan Cafferky
    Pages 203-239

  10. Augmenting ETL Processes

    • Bryan Cafferky
    Pages 241-271

  11. Configurations, Best Practices, and Application Deployment

    • Bryan Cafferky
    Pages 273-302

  12. PowerShell Versus SSIS

    • Bryan Cafferky
    Pages 303-338

  13. PowerShell Jobs

    • Bryan Cafferky
    Pages 339-373

  14. PowerShell Workflows

    • Bryan Cafferky
    Pages 375-400

  15. Back Matter

    Pages 401-407
    Download chapter PDF
Back to top

About this book

Pro PowerShell for Database Developers helps you master PowerShell application development by continuing where other books leave off. There are no "Hello World" functions here, just real-world examples that get down to business. Develop and deploy database and ETL applications in a reusable framework. Read from any data source and write to any destination. Integrate PowerShell with SQL Server.

Pro PowerShell for Database Developers shows how to dive into the PowerShell environment and customize it to your needs. Learn about CmdletBinding and its use in extending functions with powerful new features. Also learn to package functions into libraries called modules that are loaded automatically on demand.

PowerShell is about automation and getting work done when you’re not around to perform it. To that end you’ll see how to schedule PowerShell applications using SQL Agent and the scheduled job cmdlets. And for when you are around to run automated processes in person, you’ll learn to add a Windows GUI to your applications to give them that professional polish.

Other exciting topics include:

Creating objects with custom methods and properties and extending them with PowerShell-style inheritance.
  • Implementing function polymorphism using parameter sets.
  • Using PowerShell as an ETL tool surpassing even SSIS.
  • Creating distributed, interruptible, and multithreaded programs using PowerShell's workflow engine and the .Net Windows Workflow Foundation.

    • All these topics are explained using real-world examples encapsulated into modules you can immediately put to use in your organization. You’ll reap even more as you come to grips with all that PowerShell can do. Begin the journey toward deep expertise and amazing productivity. Buy and read Pro PowerShell for Database Developers today.

    About the author

    Bryan P. Cafferky is a Business Intelligence consultant and founder of BPC Global Solutions, LLC. He has decades of experience developing on the Windows platform. Originally a .Net developer, Bryan’s passion for business intelligence led him to specialize in this field with a focus on the Microsoft stack. He founded and leads the Rhode Island Microsoft Business Intelligence User Group, a SQL Pass Chapter, and he is a frequent speaker at SQL Saturdays and Code Camp events. Bryan holds an MBA from Bentley University and a degree in computer science from Bryant University. He has developed applications for banking, insurance, utilities, health, and Ecommerce industries.

    Bibliographic Information

    Publish with us

    Policies and ethics

    Back to top

    Search

    Navigation