Exegesis Spatial Data Management
Change Data Tracking for SQL Server
Posted by
19 November 2013
Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when. It can be configured for individual tables (and...
read more
Comments(0)
How to set up a MapInfo DBMS table from SQL Server without a DSN
Posted by Crispin Flower
14 November 2013
Categories:
GIS (general)
MapInfo Professional
SQL Server
A quick note to say that it is definitely possible to use a SQL Server spatial table in MapInfo Professional without an ODBC DSN. There's not much about this on the web, and the normal methods of...
read more
Comments(1)
MapInfo automatic node generation (aka stream digitizing)
Posted by Crispin Flower
04 October 2013
Categories:
MapInfo Professional
Originally posted by Timothy Derbyshire. You can press the N key on the keyboard to activate MapInfo's AutoNode function - this means that you can click once to start plotting your line, and then...
read more
Comments(0)
Optimising SQL Server spatial indexing - let sql do the work..
Posted by
01 October 2013
Categories:
GIS (general)
GISquirrel
SQL Server
Note – this will take a LONG time to run – quite possibly many hours - on a big dataset as it drops and recreates the index using different parameters – sledgehammer approach, but given the...
read more
Comments(0)
SQL Server Manager Studio 2008 bug expanding database list
Posted by Steve Ellwood
27 September 2013
Categories:
SQL Server
There is a bug within SSMS 2008 where if you connect to a db server using an account that does not have any rights to some of the database you can get an error when trying to expand the database list ...
read more
Comments(5)
ArcGIS MapLink: finding and checking dll registration
Posted by
25 September 2013
Categories:
ArcGIS
COM
MapLink
The ArcGIS extension (XGMapLinkArcGISExtension.dll) is located using COM registration. If you have multiple installations it can be confusing working out which copy you are actually running....
read more
Comments(0)
Presenting GeoServer on port 80 on a Windows IIS Server
Posted by Crispin Flower
25 June 2013
Categories:
GeoServer
IIS
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
Comments(1)
Some useful SQL server scripts relating to indexes
Posted by
16 June 2013
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
Comments(0)
Invalid column name problem with GeoServer 2.3 and SQL Server views
Posted by Crispin Flower
13 June 2013
Categories:
GeoServer
SQL Server
WMS
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
Comments(0)
Looking at PERC Raid controller log files for disk errors
Posted by
13 June 2013
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
Comments(1)
Page 5 of 13
<<
<
1
2
3
4
5
6
7
8
9
10
>
>>
Categories
.Net Core
(2)
API
(1)
AppV
(1)
ArcGIS
(9)
ASP.Net
(4)
Azure
(5)
CAMS
(1)
CGI
(2)
Cloud
(1)
Cloudscribe
(2)
COM
(1)
Fiddler
(1)
GeoServer
(12)
GIS (general)
(18)
GISquirrel
(3)
HBSMR
(13)
Identity Server 4
(1)
IIS
(11)
Internet Explorer
(1)
jQuery
(1)
LibraryLink
(2)
Load-testing
(1)
MapInfo Professional
(11)
MapLink
(5)
MapServer
(14)
Microsoft Office
(2)
Mobile
(1)
mojoPortal
(11)
MS Access
(11)
OGR/GDAL
(6)
OpenLayers
(5)
Ordnance Survey
(4)
PACS
(2)
PostgreSQL/PostGIS
(3)
Projections
(2)
Python
(6)
Quantum GIS (QGIS)
(4)
RD Gateway
(1)
Regular expressions
(2)
Remote Desktop
(3)
RemoteApp
(1)
Security
(2)
SharePoint
(1)
SQL Server
(27)
ThumbsPlus
(2)
Tilecache
(3)
UXD
(1)
VBA
(5)
Visual Studio
(4)
WFS
(3)
Windows 8
(1)
Windows Server 2008
(2)
Windows Server 2012
(1)
WMS
(5)
XSLT
(1)
Archives
June, 2020 (1)
May, 2020 (1)
October, 2019 (1)
April, 2019 (1)
February, 2019 (2)
November, 2017 (1)
March, 2017 (2)
January, 2017 (1)
July, 2016 (1)
April, 2015 (1)
March, 2015 (1)
January, 2015 (1)
December, 2014 (1)
November, 2014 (2)
October, 2014 (1)
September, 2014 (1)
July, 2014 (1)
June, 2014 (9)
April, 2014 (2)
March, 2014 (3)
February, 2014 (1)
January, 2014 (2)
December, 2013 (2)
November, 2013 (3)
October, 2013 (2)
September, 2013 (2)
June, 2013 (6)
May, 2013 (4)
April, 2013 (3)
March, 2013 (3)
February, 2013 (2)
December, 2012 (1)
November, 2012 (1)
October, 2012 (2)
September, 2012 (2)
August, 2012 (5)
July, 2012 (4)
June, 2012 (5)
April, 2012 (1)
March, 2012 (3)
February, 2012 (4)
January, 2012 (8)
December, 2011 (6)
November, 2011 (10)
September, 2011 (1)
December, 2010 (1)
November, 2010 (1)
April, 2010 (1)
December, 2009 (2)
February, 2008 (1)
February, 2007 (1)
October, 2006 (1)
May, 2006 (1)
April, 2006 (2)