Saturday, August 17, 2019

Pro PowerShell for Database Developers (Free PDF)

File Size: 8.75 Mb

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 client had already started coding these tasks as legacy-style batch files. The deadlines were tight, and the client did not want any delays. As I reviewed the batch files, with their cryptic coding, I knew investing in this outdated technology was the wrong way to go. I convinced them to let me rewrite the scripts in PowerShell.

It was a challenge to learn a new language from scratch while developing a solution with frequent deliverables, but it turned out to be the right decision. The final solution was scalable, extensible, and reusable. Most important, my passion for PowerShell started.

Before long, I started doing PowerShell presentations at PASS chapter meetings, Code Camps, and SQL Saturdays. The more I learned about PowerShell, the more excited I became. However, I found it difficult to find books or blogs that did anything but Windows Administration tasks. I used bits and pieces of these to cobble together what I needed. I was surprised that no one had written a book that covered application or database development. Professional colleagues agreed this was lacking, which kept many from adopting PowerShell. Maybe I could step up and fill in the gap?

About the Author
About the Technical Reviewer
Chapter 1: PowerShell Basics
Chapter 2: The PowerShell Language
Chapter 3: Advanced Programming
Chapter 4: Writing Scripts
Chapter 5: Writing Reusable Code
Chapter 6: Extending PowerShell
Chapter 7: Accessing SQL Server
Chapter 8: Customizing the PowerShell Environment
Chapter 9: Augmenting ETL Processes
Chapter 10: Configurations, Best Practices, and Application Deployment
Chapter 11: PowerShell Versus SSIS
Chapter 12: PowerShell Jobs
Chapter 13: PowerShell Workflows

Author Details
"Bryan Cafferky"

Download Drive-1

You May Also Like These E-Books:-

No comments:

Post a Comment