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] […]
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 – 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 […]
Screenshots of upgrading SQL Server 2016 to SQL Server 2017 [vNext – the latest release as the posting of this atricle]
See below code:
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.
For SQL 2014/2016: Concise guide here: Quick Start: Extended events in SQL Server – click here Root URL on extended events – click here.