While setting up a new mojoPortal site I tried our running the application pool with the identity “ApplicationPoolIdentity”. Previously we have tended to create a specific user account for each site... read more

Basically the user was complaining that they could not turn layers on and off in the Table of Contents (the left hand pane) but they could go in to the properties of the layer and turn... read more

When connecting to any mapping web service, such as a WMS of WFS, just occasionally things don’t work first time (or is that just me…?). When this happens it is useful to be able to inspect the HTTP... read more

A SQL Server DBA reported many login failures in his SQL logs. These failures were not apparent to system users. The connection string included the clause <Trusted_Connections=Yes>, this should have been <Trusted_Connection=Yes>. Once the connection string had been corrected the log-in failures stopped.

... read more

I hit a problem where I needed to enable network access to SQL Server 2008 Express R2 which was on a Win7 64bit OS. the solution was previously posted at:... read more

Andy Brewer passed me this, adapted from http://barendgehrels.blogspot.co.uk/2011/04/extent-of-sql-server-spatial-table.html This is a useful script, using CTEs (common table expressions) to... read more

The MIDAS xml export from the HBSMR Monument Index form includes an out-of-date URL link for the MIDAS xml schema. This means that anybody trying to import the data into a database or other... read more

We are using TileCache http://tilecache.org/ to create caches of Ordnance Survey data of various flavours, for use in high demand web sites. We are tending to pre-seed the caches, then access them... read more

When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions. The solution is of course common knowledge now, but I can... read more

MS Access can be a nice interface onto SharePoint. We’ve been implementing this for a client, allowing files and metadata that are managed in HBSMR (Access UI onto SQL Server database) to be... read more