PowerShell incorporates both a command line interface and scripting language, and is designed to automate system tasks, as well as aid in configuration management. It was first released by Microsoft back in November 2006 for use in its Windows operating system, however, in August 2016, it was made open source and available on additional platforms including, macOS and various Linux distributions, such as Debian, Ubuntu, Red Hat and CentOS.
PowerShell was initially built on the .NET Framework, however, when it was made open source and available across multiple platforms, this changed to .NET Core, both of which are from Microsoft.
Below are some of the basics of the PowerShell scripting language.
- Getting Started
- Decision Making
- Regular Expressions
- SQL Server – Importing Data
- SQL Server – Exporting Data (CSV)
- SQL Server – Exporting Data (XML)
- SQL Server – Generating Data