Author: Steve M
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)?
See below code:
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
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.
Quick Start: Extended events in SQL Server
Setup Active Directory on Windows server 2012 R2, Windows Server 2016
Screenshots on setting up active Directory on Windows Server 2012/2016:
- after installing Windows Server and running all updates
- Add the role Active Directory – server manager,local server,add roles and features wizard, AD Domain services
