update-help
set-executionpolicy remotesigned
$PSversiontable
get-module
import-module SQLPS
psdrive
import-module -Name SQLServer -Scope CurrentUser -AllowClobber
Month: August 2017
Powershell Notes: SSMS 2017
Database mail failure – SQL Server 2016 – On Windows Server 2016
Issue:
SQL Server 2016 would not send mail on a new server migration to Windows Server 2016
Solution:
By default, Windows Server 2016 installs .net framework 4.7
The database mail feature needs .Net 3.5
Install this windows feature and this issue gets resolved.