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 Posted by 21 February 2019 Categories: MapServer SQL Server WFS Comments(0)
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 Posted by 03 November 2017 Categories: .Net Core API Cloudscribe Identity Server 4 Security SQL Server Visual Studio Comments(6)
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 Posted by Crispin Flower 30 March 2017 Categories: MS Access SQL Server Comments(0)
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 Posted by Crispin Flower 11 January 2017 Categories: GeoServer OGR/GDAL SQL Server WFS Comments(0)
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 Posted by 12 March 2015 Categories: SQL Server Comments(1)
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 Posted by Timothy Derbyshire 05 December 2014 Categories: SQL Server Comments(0)
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 Posted by Crispin Flower 13 November 2014 Categories: GeoServer PostgreSQL/PostGIS SQL Server Comments(0)
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 Posted by Steve Ellwood 22 September 2014 Categories: SQL Server Comments(0)
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 Posted by 02 March 2014 Categories: SQL Server Comments(1)
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 Posted by 28 December 2013 Categories: GIS (general) OGR/GDAL Projections SQL Server Comments(0)