Create a Microsoft Azure SQL Database in screenshots guide.
Creating a Azure SQL Managed Instance database, in Screen shots.
SQL Server 2017 Development Edition Installation – installation source , click here.
When below error occurs, remember to change the Tesselation scheme, in this case from Geometry grid to Geography auto [if the case] Example code: SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF GO CREATE SPATIAL INDEX [SpatialIndex-Vegetation1] ON [dbo].[VEGETATION1] […]
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 […]
update-help set-executionpolicy remotesigned $PSversiontable get-module import-module SQLPS psdrive import-module -Name SQLServer -Scope CurrentUser -AllowClobber
Error screenshots and resolution. Issue from SSMS 2017 – Click here to download SSMS 2017 Get Powershell Gallery from this link. Click here.
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.
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