O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

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

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_2

2. PowerShell Fundamentals

Peter A. Carter

(1)Botley, UK

PowerShell is a scripting language, developed by Microsoft, that is capable of managing virtually every aspect of Windows and resources that sit on Windows, such as SharePoint and SQL Server. It is object-based and integrated with the .NET Framework. It can be used to run scripts both locally and remotely. The following sections will discuss the fundamentals of PowerShell, before a closer look is taken at the sqlps module and how to navigate an instance.

Getting Started with PowerShell

The following sections will introduce the PowerShell Command Line Interface and Integrated ...

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