Exegesis Spatial Data Management

 

Posts in Category: SQL Server

Mapserver returning WFS attributes scrambled when using msplugin_mssql2008 plugin

We recently upgraded Mapserver to the current version for a project because we wanted the WFS id field to be populated in geojson which required a recent version of (OGR >=2.3) which was included... read more
 

Using cloudscribe with Identity Server 4 with a SQL Server store on .Net Core 2 MVC securing APIs

Well that’s a bit of a mouthful of a title – but it does describe what I was trying to do, and I didn’t find it easy. It’s not that complicated when you know how, but there are an awful lot of... read more
 

How to link SQL Server / RDBMS tables into MS Access without a DSN

Linking tables from RDBMS like SQL Server into an Access front end doesn't need an ODBC DSN to be configured, it can be done with a one-liner. I’m just posting this here because I keep having to look ... read more
 

GeoServer WFS fails on SQL Server tables/views with GUID data type

Just a quick note that might be useful to some. The problem... If you publish a SQL Server (in this case 2014) table or view with a GUID field using GeoServer (version 2.10), it will fail to... read more
 

Troubleshooting issues with VSS from backup chain and SQL Server

Symptoms: BackupChain fails almost as soon as it starts when backing up SQL Server VM SQL server VM Application log is riddled with errors Diagnostics: Use VSSDiag You can start by using the VssDiag... read more
 

Confusion when renaming SQL Server views

Renaming views in SQL Server Management Studio can lead to unforseen consquences later, such as views failing to recompile or having their structure changed without warning. This post explains the causes of these problems and some potential solutions.

... read more
 

WMS/WFS down when a GeoServer store is disabled after Windows updates

Last night some of our servers restarted after scheduled updates, and we awoke to warning emails that some of our GIS web services were down. The affected WMS/WFS services were from GeoServer, so we... read more
 

SQL Server - Listing all tables in database, the space used and row counts

This is a very useful SQL script to listing all of the tables in a SQL Server database with the row count and the amount of space being used by that table, handy for troubleshooting databases that... read more
 

Remote connection to SQL server on dynamic ports

SQL server has conventionally used port 1433. However recently Microsoft made some changes and when suing named instanced you are likely to find your SQL Server is using dynamic ports. This means ... read more
 

Using R with spatial data

R is a cross platform statistical package which is becoming extremely widely used. It is modular and so there are all sorts of add ins available, including a number of sophisticated tools for... read more
 
Page 1 of 3 1 2 3 > >>
https://www.esdm.co.uk/Blog/ViewCategory.aspx?cat=4&mid=108&pageid=138