Book Image

Learn PowerShell Core 6.0

By : David das Neves, Jan-Hendrik Peters
Book Image

Learn PowerShell Core 6.0

By: David das Neves, Jan-Hendrik Peters

Overview of this book

Beginning with an overview of the different versions of PowerShell, Learn PowerShell Core 6.0 introduces you to VSCode and then dives into helping you understand the basic techniques in PowerShell scripting. You will cover advanced coding techniques, learn how to write reusable code as well as store and load data with PowerShell. This book will help you understand PowerShell security and Just Enough Administration, enabling you to create your own PowerShell repository. The last set of chapters will guide you in setting up, configuring, and working with Release Pipelines in VSCode and VSTS, and help you understand PowerShell DSC. In addition to this, you will learn how to use PowerShell with Windows, Azure, Microsoft Online Services, SCCM, and SQL Server. The final chapter will provide you with some use cases and pro tips. By the end of this book, you will be able to create professional reusable code using security insight and knowledge of working with PowerShell Core 6.0 and its most important capabilities.
Table of Contents (26 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

SQL Server


Microsoft SQL Server is a complex server product, with many components and tools that enable consumer success. Due to this, perfect tooling for PowerShell is not always available. On the other hand, it has one of the most active user communities, driving rapid improvement and expansion of the available tool-sets.

 

Currently, there are four major PowerShell modules to choose from:

SqlServer

The official and supported module developed by Microsoft. It contains tools to navigate and manage SQL instances.

ReportingServicesTools

The equally official module managed by Microsoft that handles managing reporting services. Unlike the SqlServer module, it is open source and the community can contribute to it on GitHub.

dbatools

The largest community-driven PowerShell module in existence. More than 400 commands that deal with SQL Instances, covering many of the tasks that the long-neglected official SqlServer module could not handle.

dbachecks

A community project that marries dbatools to Pester, offering...