exeGesIS Spatial Data Management

 

MapInfo automatic node generation (aka stream digitizing)

Originally posted by Timothy Derbyshire. You can press the N key on the keyboard to activate MapInfo's AutoNode function - this means that you can click once to start plotting your line, and then... read more
 

Optimising SQL Server spatial indexing - let sql do the work..

Note – this will take a LONG time to run – quite possibly many hours - on a big dataset as it drops and recreates the index using different parameters – sledgehammer approach, but given the... read more
 

SQL Server Manager Studio 2008 bug expanding database list

There is a bug within SSMS 2008 where if you connect to a db server using an account that does not have any rights to some of the database you can get an error when trying to expand the database list ... read more
 

ArcGIS MapLink: finding and checking dll registration

The ArcGIS extension (XGMapLinkArcGISExtension.dll) is located using COM registration. If you have multiple installations it can be confusing working out which copy you are actually running.... read more
 

Presenting GeoServer on port 80 on a Windows IIS Server

We run several instances of GeoServer on Windows servers, using the Jetty web server included in the GeoServer for Windows installer. By default this results in a service running on an address like... read more
 

Some useful SQL server scripts relating to indexes

To check index use:SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME], I.[NAME] AS [INDEX NAME], USER_SEEKS, USER_SCANS, USER_LOOKUPS, USER_UPDATES FROM ... read more
 

Invalid column name problem with GeoServer 2.3 and SQL Server views

I have been getting this error with a WMS layer based on a SQL Server 2008 view, when using a GetFeatureInfo request: java.lang.RuntimeException: java.io.IOException java.io.IOException null... read more
 

Looking at PERC Raid controller log files for disk errors

Log files can be obtained from Dells OpenManage interface – see below: This can show up disk errors and RAID errors for disks that have yet themselves to flag themselves as failing. This can cause... read more
 

Merging Hyper-V virtual machine snapshots – monitoring progress

Its not a great idea to run with multiple snapshots in a production setup as it slows things down. If you remove a snapshot in Hyper-V manager you might think that that's the job done. Well it isn’t... read more
 

SQL server log files–reducing size

On ESDM-SQL1 all databases that are added should have their backup strategy set to SIMPLE (as opposed to FULL). This means that we can recover to last nights backup in the event of disaster – but we... read more
 
Page 5 of 13 << < 1 2 3 4 5 6 7 8 9 10 > >>
https://www.esdm.co.uk/Blog/ViewList.aspx?pageid=138&mid=108&pagenumber=5