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

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.