Exegesis Spatial Data Management

 

Posts in Category: SQL Server

How to fix orphaned SQL Server users

Posted by Crispin Flower 17 February 2012 Categories: SQL Server
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
 
Comments(1)

Breaking a site with Multi-Mechanize

Posted by Crispin Flower 28 December 2011 Categories: IIS Load-testing Python SQL Server
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
 
Comments(0)

MS Access DAO recordset + SQL Server: how to get the ID of a newly inserted record

Posted by Crispin Flower 23 December 2011 Categories: HBSMR MS Access SQL Server VBA
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
 
Comments(1)

SQL Server 2005: how to allow remote connections

Posted by Crispin Flower 08 December 2011 Categories: SQL Server
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
 
Comments(0)

Some jottings on SQL Azure and GIS

Posted by Crispin Flower 19 November 2011 Categories: ArcGIS Azure GIS (general) GISquirrel MS Access OGR/GDAL Quantum GIS (QGIS) SQL Server

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

... read more
 
Comments(1)

Notes on importing spatial data into SQL Server 2008

Posted by Crispin Flower 17 November 2011 Categories: ArcGIS GIS (general) GISquirrel MapInfo Professional SQL Server
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
 
Comments(1)

How to recompile all views in SQL Server

Posted by Crispin Flower 21 April 2006 Categories: SQL Server
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
 
Comments(0)
Page 3 of 3 << < 1 2 3
  • RSS
https://www.esdm.co.uk/Blog/ViewCategory.aspx?cat=4&pageid=138&mid=108&pagenumber=3