SQLMint: Dynamic SQL Server Solutions
This event has a lot of good video resources. The current/next one will be in Sept 2020 at New Orleans, LA – subject to Microsoft confirmation due to the Covid-19 outbreak. These – event recorded sessions – are also available on pluralsight. Click here for the main website. Click here for some past Session videos.
Heres the error that kept popping up while trying to move a SQL Server Instance node from one node to another – on a Windows 2016 Server cluster, running SQL Server 2019 Useful solution links. Link 1
Click here for the website link.
Got this error below while attempting to run DQC – Data Quality Client – which previously worked on this SQL Server which had previously an ok/verified DQS – Data Quality Server installation. Error text: SQL Server Data Quality Services ——————————————————————————– Message Id: LogOnWindowFailedToConnect Cannot connect to <SERVER>. A .NET Framework error occurred during execution of […]
SQL Server 2017 Development Edition Installation – installation source , click here.
SQL Server 2016 Cluster – Partially Running [half red/half green] – came across below issue, and upon further investigation l noticed the nodes has CEIP versions of Analysis services as well as Agent. Simply removing these roles, returned the server roles status to running/green Click here for reference link on msdn.microsoft forum 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] […]
Reference link: Click here for the reference link. Screenshot – after Removing SQL 2005 using Programs Add/Remove on Windows Server :