O'Reilly logo

Pro PowerShell for Database Developers by Bryan Cafferky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

My introduction to PowerShell came from a webinar presented by Pragmatic Works’ consultant and Microsoft MVP, Robert Cain. I was amazed by PowerShell but did not have an immediate application for it. Then, I started on a contract to migrate a client from a cloud architecture to a hybrid of cloud and on-premises SQL Server. The ETL tool was not SQL Server Integration Services, and it had a number of limitations. We needed to load external files, which required a good deal of pre-processing. For example, we needed to decrypt the files and unzip them. In some cases, we needed to add a header row with column names. Multiple files had to be consolidated into one file before loading. After processing, the files had to be archived. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required