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 Posted by Crispin Flower 25 June 2013 Categories: GeoServer IIS Comments(1)
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 Posted by 16 June 2013 Comments(0)
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 Posted by Crispin Flower 13 June 2013 Categories: GeoServer SQL Server WMS Comments(0)
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 Posted by 13 June 2013 Comments(1)
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 Posted by 12 June 2013 Comments(0)
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 Posted by 12 June 2013 Comments(0)