Pro PowerShell for Database Developers

by Bryan P. Cafferky

Overview

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.

Product Details

ISBN-13:	9781484205426
Publisher:	Apress
Publication date:	10/07/2015
Edition description:	1st ed.
Pages:	407
Product dimensions:	7.01(w) x 10.00(h) x (d)

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.

Table of Contents

Introduction

1. Grasping PowerShell Basics

2. Introducing the Language

3. Learning Advanced Features

4. Writing Simple Scripts

5. Creating Reusable Code

6. Extending PowerShell

7. Accessing SQL Server

8. Customizing the PowerShell Environment

9. Augmenting ETL Processes

10. PowerShell Application Configurations, Development Best Practices and Application Deployment

11. PowerShell versus SSIS

12. PowerShell Jobs

13. Multi-threading with Wndows Workflow