Download Visual Studio Code

https://code.visualstudio.com/download

How to install Visual Studio Code and configure it as a replacement for the PowerShell ISE

https://www.youtube.com/watch?v=1sD-RktG_dM

Use Visual Studio Code for PowerShell Development

https://code.visualstudio.com/docs/languages/powershell

ImportExcel Module on GITHUB

https://github.com/dfinke/ImportExcel

PowerShell 6

https://www.thomasmaurer.ch/2019/03/how-to-install-and-update-powershell-6/
C:\Program Files\PowerShell\6\pwsh

PowerShell on GITHUB

https://github.com/PowerShell/PowerShell

Searching SQL Servers & Saving Results, with Write-SqlTableData

http://sqlvariant.com/2016/10/quick-blog-searching-sql-servers-saving-results-with-write-sqltabledata/

Get Free Space Per Drive Mount Point

http://sqlvariant.com/2017/05/finding-free-space-per-drive-mount-point-in-powershell/

Export Adventureworks Tables Using Export-Excel

http://sqlvariant.com/2019/03/export-adventureworksdw2017-to-excel-for-a-powerbi-demo-with-export-excel-in-powershell/

Achieve more in less time using the new SQL PowerShell - THR2114

https://www.youtube.com/watch?v=3tVnNm-w4Bg

Where is PowerShell.exe

Open command prompt
where PowerShell

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe

Query the PowerShell Version You're Running

$PSVersionTable

Name                           Value                                                                                 
----                           -----                                                                                 
PSVersion                      5.1.17134.590                                                                         
PSEdition                      Desktop                                                                               
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                               
BuildVersion                   10.0.17134.590                                                                        
CLRVersion                     4.0.30319.42000                                                                       
WSManStackVersion              3.0                                                                                   
PSRemotingProtocolVersion      2.3                                                                                   
SerializationVersion           1.1.0.1


$PSVersionTable.PSVersion

Major  Minor  Build  Revision
-----  -----  -----  --------
5      1      17134  590 


$PSVersionTable.PSVersion.Major

5

Import Excel How-To Videos

https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

Using the ImportExcel PowerShell Module by Doug Finke

https://www.youtube.com/watch?v=4Xw7r6436w0