A regular expression for numbers from 0 to 100 I've been creating a web questionnaire (using the Forms Wizard module for mojoPortal CMS) that includes some questions where the answers were to be expressed as integer percentages. How to validate... read more Posted by Crispin Flower 29 July 2016 Categories: ASP.Net Regular expressions Comments(7)
How to change the port for GeoServer on Windows with Jetty Faced with the task of upgrading a production GeoServer under heavy constant use, I decided to install the newer version alongside first, migrate the content, then make the switch when I was happy... read more Posted by Crispin Flower 19 April 2015 Categories: GeoServer IIS Windows Server 2008 Comments(3)
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)
How to do a typeahead incremental search control in Microsoft Access When a user needs to find an existing record or value by typing something in a box, it is well recognized that a "typeahead" or incremental search is a powerful and user-friendly solution. Of... read more Posted by Crispin Flower 11 January 2015 Categories: MS Access UXD VBA Comments(7)
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)
MapInfo Pro requests node-locked activation method rather than Licence server details when activating a concurrent licence This issue may occur where users have been switched from using node-locked to concurrent MapInfo licences. Although the served version of MapInfo is installed, when MapInfo is run the dialog for... read more Posted by Claire Lush 12 November 2014 Categories: MapInfo Professional Comments(0)
How to suppress sponsor offers when installing or updating Java When you update Java, you are usually offered the Ask toolbar, default home page and search. You have to opt out of this offer every update and, until recently, there was no way to avoid this without ... read more Posted by Andy Brewer 23 October 2014 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)
RemoteApp connection issue with Server 2012 from Windows 7 & 8 PCs (with Event ID 4625 in the Event log) Having just built a nice new shiny Window Server 2012 VM with Remote Desktop Gateway Services installed we encountered a problem where one user was not able to start RemoteApp applications from their ... read more Posted by Steve Ellwood 29 July 2014 Categories: RD Gateway Remote Desktop RemoteApp Windows 8 Windows Server 2012 Comments(11)