Configuring ArcGIS Server for SQL Server course

Recently I have been teaching an ArcGIS Server Enterprise Configuration and Tuning for SQL Server course that Esri also now offers for ArcGIS 10. Originally, it was designed for the previous versions, but it has been rewritten and updated in order to reflect the new interface and functionality of the version 10. The course is [...]

Read Full Post »

Creating ArcSDE services

Today I would like to discuss a fairly typical scenario, which is when you have worked with an ArcSDE database on a development server and then have backed it up and restored it on a production server. After running all the required scripts and eventually after doing user mappings, you will have moved to the [...]

Read Full Post »

Change sde layers path

If you have an .mxd document that has a large number of layers and you have to use another sde database as a source of data, which includes the same feature classes and tables (for instance, when moving from a development to a production server), you might need to change source paths for those layers. [...]

Read Full Post »

More useful SQL Server commands

When you modify a table in SQL Server (I still use mostly SQL Server 2005) and try to uncheck an Allow Nulls option for a certain field (thus prohibiting having NULL values in this column), the following error may occur: Cannot insert the value NULL into column ‘<columnname>’, table ‘<dbname>.dbo.Tmp_<tablename>’; column does not allow nulls. [...]

Read Full Post »

Useful SQL statements and ArcSDE commands

ArcSDE A lot of work during administration of ArcSDE includes managing sde instances. I just wanted to write down some of the most useful and often used ArcSDE administration commands I have been using for a while. Parameters embraced in <> are defined by user; so, if we have “<servicename>” that would result to “esri_sde”. [...]

Read Full Post »