SQL Server 2005 Components Cleanup
Reference link:
Click here for the reference link.
Screenshot – after Removing SQL 2005 using Programs Add/Remove on Windows Server :
Active Directory Creation On Windows Server 2016
Active Directory Creation On Windows Server 2016 – using a Virtual Machine running under Windows 10 Pro Hyper-V
Screenshots:
DNS:
AD should now be functional, for other servers to join this domain.
Note, most core production servers use static ip addresses , and not dynamic/DHCP as might be seen in the screenshots above.
Upgrading SQL Server 2016 to SQL Server 2017
Screenshots of upgrading SQL Server 2016 to SQL Server 2017 [vNext – the latest release as the posting of this atricle]
T-SQL: How to export image field data to file(s)?
SQL – Powershell Useful Command(s)
update-help
set-executionpolicy remotesigned
$PSversiontable
get-module
import-module SQLPS
psdrive
import-module -Name SQLServer -Scope CurrentUser -AllowClobber
Powershell Notes: SSMS 2017
Error screenshots and resolution.
Issue from SSMS 2017 – Click here to download 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.