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