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

In my previous post I got started with Multi-Mechanize and established that it is a useful tool for load-testing web sites. Next I tried it on a real site that we are currently building – the new... read more

Sometimes when inserting records programmatically you want to create a parent record first, then add records into related tables where the Foreign Key is on an autonumber field. Therefore you need to ... read more

When running instances of SQL Server on laptops/PCs, it can be troublesome allowing others on the network to connect to them. Keith Westcott has written up this guide. Obviously paths may need to be... read more

I have set up a SQL Azure 90 day trial (as of 18th November) to test whether ArcSquirrel can work

... read more

There are a variety of ways to do this, but often you will hit issues with data validity. If you have our ArcGIS Maplink product (or ArcSquirrel) then loading data in using this into a... read more

DECLARE @viewname varchar(128) DECLARE @viewname_header varchar(128) DECLARE vnames_cursor CURSOR FOR SELECT name FROM sysobjects WHERE type = 'v' OPEN vnames_cursor FETCH NEXT FROM... read more