A quick tour of geodatabases in Microsoft SQL Server
A quick tour of setting up a geodatabase in SQL Server
A comparison of geodatabase owners in SQL Server
Setting up a connection to SQL Server
Creating a database and geodatabase in SQL Server
Scripting database and geodatabase creation in SQL Server
Using a Windows-authenticated sde login in SQL Server
Enabling geodatabase functionality in an existing SQL Server database
Multiple geodatabases in one instance of SQL Server
What is geodatabase configuration?
Minimize disk I/O contention in SQL Server
Memory tuning in SQL Server
The SERVER_CONFIG system table
Buffer size initialization parameters
Altering SERVER_CONFIG parameters
What are ArcSDE log file tables?
Log file table configuration options for geodatabases in SQL Server
In what order do ArcSDE log file types get used?
What is the DBTUNE table?
What are DBTUNE configuration keywords and parameters?
SQL Server DBTUNE configuration parameters
Parameters for ArcSDE XML in SQL Server
Types of configuration keywords
Default configuration keywords specific to SQL Server
The DEFAULTS keyword in SQL Server
The LOGFILE_DEFAULTS keyword in SQL Server
Composite keywords and geometry storage
Custom configuration keywords
Altering the contents of the DBTUNE table
Making configuration keywords available in ArcGIS
Preparing SQL Server to store ArcSDE XML columns
Creating a full-text catalog in SQL Server using Management Studio
Creating a full-text catalog in SQL Server using SQL
Setting the full-text search engine language in SQL Server
What are user accounts?
Operating system authentication
A comparison of Windows and database authentication in SQL Server
Adding Windows-authenticated logins or groups to a SQL Server database
Adding database-authenticated logins to a SQL Server database
The geodatabase administrator in SQL Server
User groups or roles
Tips for grouping users
Windows groups in geodatabases in SQL Server
What are user privileges?
User privileges for geodatabases in SQL Server
Granting and revoking privileges on datasets
A quick tour of connections to enterprise geodatabases
Compatibility when connecting directly from ArcGIS clients to geodatabases in SQL Server
Setting up a connection to SQL Server
Database connections in ArcGIS for Desktop
Preparing database connection files to share with other users
Connecting to a specific geodatabase version
Connections to a SQL Server database mirroring session
Viewing connected users in ArcGIS for Desktop
Preventing users from connecting to a geodatabase
Removing connections from a geodatabase in SQL Server
Troubleshooting connections to a database
What is an ArcSDE service?
A quick tour of ArcSDE services
The services.sde file
Making an ArcSDE service connection from ArcGIS
Compatibility between clients and geodatabases in SQL Server when using an ArcSDE service
Displaying ArcSDE service statistics
Displaying connected sessions
ArcSDE services inside a firewall
Troubleshooting an ArcSDE service
Editing service files on Windows
Creating an ArcSDE service on Windows using the sdeservice command
Creating an ArcSDE service from a remote Windows server
Starting a local ArcSDE service on Windows
Starting a remote ArcSDE service on Windows
Setting up multiple ArcSDE services on one Windows server
Stopping a local ArcSDE service on Windows
Stopping a remote ArcSDE service
Pausing a local ArcSDE service on Windows
Pausing an ArcSDE service using sdemon
Resuming a local ArcSDE service on Windows
Resuming an ArcSDE service using sdemon
What type of maintenance is needed for a geodatabase?
Database backup and recovery
SQL Server backups
Recovery models for SQL Server
Geodatabase version administration
The geodatabase compress operation
Compressing an enterprise geodatabase
Database statistics
Updating statistics on a dataset using the Analyze Datasets tool
Statistics in SQL Server databases
Managing SQL Server database full-text indexes
A quick tour of enterprise geodatabase upgrades
Preparing to upgrade a geodatabase in SQL Server
Uninstalling ArcSDE from Windows
Upgrading a geodatabase in SQL Server
Upgrade Geodatabase
Scripting an enterprise geodatabase upgrade in SQL Server
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 64 bit
Migrating from a multiple database to a single database geodatabase in SQL Server
Methods for moving a geodatabase in SQL Server
Moving a geodatabase using an XML document
Migrating from a multiple database to a single database geodatabase in SQL Server
What's inside a geodatabase in SQL Server?
SQL Server data types supported in ArcGIS
What are user-defined data types?
ArcSDE compressed binary storage
The OGC Well-Known Binary representation for geometry
ArcGIS and Microsoft spatial types
Raster storage types in an ArcSDE geodatabase
What is the ST_Raster storage type?
XML columns in a geodatabase in SQL Server
What are XML schemas in enterprise geodatabases?
Data migration from one storage type to another
Migrating raster columns to the ST_Raster type using the Migrate Storage geoprocessing tool
Feature classes in a geodatabase in SQL Server
Subtypes in feature classes in a geodatabase in SQL Server
Domains in a geodatabase in SQL Server
Feature datasets in a geodatabase in SQL Server
Topologies in a geodatabase in SQL Server
Geometric networks in a geodatabase in SQL Server
Network datasets in SQL Server
Parcel fabrics in a geodatabase in SQL Server
Schematic datasets in a geodatabase in SQL Server
Terrain datasets in a geodatabase in SQL Server
Relationships between datasets in a geodatabase in SQL Server
Locators in a geodatabase in SQL Server
Toolboxes in geodatabases in SQL Server
Raster datasets and raster catalogs in a geodatabase in SQL Server
Mosaic datasets in a geodatabase in SQL Server
Versioned tables in a geodatabase in SQL Server
Replicas in a geodatabase in SQL Server
Archives in a geodatabase in SQL Server
Keyset tables in a geodatabase in SQL Server
ArcSDE log file tables in a geodatabase in SQL Server
System tables of a geodatabase in SQL Server
What is a view?
A quick tour of views in the geodatabase
Views in SQL Server
Creating a database view in ArcGIS for Desktop
Example: Creating a database view in SQL Server using SQL
Example: Creating a spatial view in SQL Server using SQL