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

Security Update for SQL Server 2014 Service Pack 2 GDR (KB3194714)

“KB Articles: KB3194714 Security bulletins:SQL Server 2014 MS16-136 Security issues have been identified in SQL Server 2014 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to […]

Read More

Microsoft R – SQL 2016 – Notes

“R is a free software environment for statistical computing and graphics” – source click here. Useful links: Getting Started with Microsoft R Client Microsoft R Installing DeployR for Microsoft R Server 2016 (8.0.5) on Windows Set up SQL Server R Services (In-Database) SQL Server 2016 R Services: Guide for Server Configuration   Quick notes: You […]

Read More