SQL Server Error – SSMS GUI – Mismatch in column datatype and tessellation scheme

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] […]

Read More

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 […]

Read More