A quick tour of geodatabases in Microsoft SQL ServerA quick tour of setting up a geodatabase in SQL ServerSystem requirements to install ArcSDE for SQL ServerSQL Server initialization parametersA comparison of geodatabase owners in SQL ServerInstalling ArcSDE for SQL ServerCreating a geodatabase in SQL ServerAuthorizing ArcSDE geodatabases in SQL ServerCreating and starting an ArcSDE service for SQL ServerInstallations of SQL Server and ArcSDE on separate serversCreating an ArcSDE service from a remote Windows serverMultiple geodatabases in one instance of SQL ServerSetting up multiple ArcSDE services on one Windows serverThe SQL Server multiple spatial database modelPreparing SQL Server to store ArcSDE XML columnsCreating a full-text catalog in SQL Server using Management StudioCreating a full-text catalog in SQL Server using SQLSetting the full-text search engine language in SQL ServerWhat is geodatabase configuration?The giomgr.defs file and the SERVER_CONFIG system tableBuffer size initialization parametersAltering SERVER_CONFIG parameters before the geodatabase is createdAltering SERVER_CONFIG parameters after the geodatabase is createdWhat are ArcSDE log file tables?Log file table configuration options for geodatabases in SQL ServerIn what order do ArcSDE log file types get used?The services.sde fileThe dbinit.sde fileEnvironment variablesWhat is the dbtune file?What is the DBTUNE table?What are DBTUNE configuration keywords and parameters?SQL Server DBTUNE configuration parametersParameters for ArcSDE XML in SQL ServerTypes of configuration keywordsDefault configuration keywords specific to SQL ServerThe DEFAULTS keyword in SQL ServerThe DATA_DICTIONARY keyword in SQL ServerThe LOGFILE_DEFAULTS keyword in SQL ServerComposite keywords and geometry storageCustom configuration keywordsAltering the dbtune file before creating the geodatabaseAltering the contents of the DBTUNE table after it has been createdMaking configuration keywords available in ArcGISMinimize disk I/O contention in SQL ServerMemory tuning in SQL ServerWhat are user accounts?A quick tour of adding and administering users in SQL ServerOperating system authenticationA comparison of Windows and database authentication in SQL ServerAdding Windows-authenticated logins or groups to a SQL Server databaseAdding database-authenticated logins to a SQL Server databaseThe ArcSDE administrative account in SQL ServerUsing a Windows-authenticated sde login in SQL ServerUser groups or rolesTips for grouping usersWindows groups in geodatabases in SQL ServerWhat are user permissions?User permissions for geodatabases in SQL ServerGranting and revoking privileges on datasetsA quick tour of connections to ArcSDE geodatabasesGeodatabase connections in ArcGIS DesktopPreparing database connection filesConnecting to a specific geodatabase versionPreventing users from connecting to a geodatabaseMaking a connection from ArcIMS to a geodatabase in SQL ServerWhat is a direct connection to a geodatabase in SQL Server?What are direct-connect drivers?Direct-connect compatibility between clients and ArcSDE geodatabases in SQL ServerSetting up a direct connection to SQL ServerMaking a direct connection from ArcGIS Desktop to a geodatabase in SQL ServerDirect connections from ArcSDE commands to a geodatabase in SQL ServerConnecting to the default version of a dbo-schema geodatabase from ArcGIS DesktopRemoving direct connections from the geodatabaseTroubleshooting direct connections to an ArcSDE geodatabaseWhat is an ArcSDE service?A quick tour of ArcSDE servicesCompatibility between clients and geodatabases in SQL Server when using an ArcSDE serviceMaking an ArcSDE service connection from ArcGIS Desktop to a geodatabase in SQL ServerRemoving an ArcSDE service connection from the geodatabaseDisplaying ArcSDE service statisticsDisplaying connected sessionsArcSDE services inside a firewallTroubleshooting an ArcSDE serviceCreating an ArcSDE service on Windows using the sdeservice commandCreating an ArcSDE service from a remote Windows serverStarting a local ArcSDE service on WindowsStarting a remote ArcSDE service on WindowsStopping a local ArcSDE service on WindowsStopping a remote ArcSDE servicePausing a local ArcSDE service on WindowsPausing an ArcSDE service using sdemonResuming a local ArcSDE service on WindowsResuming an ArcSDE service using sdemonWhat type of maintenance is needed for a geodatabase?Database backup and recoverySQL Server backupsRecovery models for SQL ServerGeodatabase version administrationThe geodatabase compress operationAdding the Compress command to ArcCatalogCompressing an ArcSDE geodatabase licensed under ArcGIS Server EnterpriseDatabase statisticsUpdating statistics on a geodatabase using the Analyze commandStatistics in SQL Server databasesManaging SQL Server database full-text indexesA quick tour of ArcSDE geodatabase upgradesWhat is a service pack or patch?Preparing to upgrade a geodatabase in SQL ServerUninstalling ArcSDE from WindowsUpgrading an ArcSDE geodatabase in SQL ServerUpgrade GeodatabaseScripting an ArcSDE geodatabase upgrade in SQL ServerUpgrade NetworkUpgrade Parcel FabricMigrating to ArcSDE 64 bit on Windows when the existing DBMS is 32 bitMigrating to ArcSDE 64 bit on Windows when the existing DBMS is 64 bitMoving a geodatabase using ArcSDE export filesMoving a geodatabase using an XML documentOther methods for moving a geodatabase in SQL ServerWhat's inside a geodatabase in SQL Server?A comparison of ArcGIS, ArcSDE, and SQL Server data typesWhat are user-defined data types?ArcSDE compressed binary storageThe OGC Well-Known Binary representation for geometryArcSDE and Microsoft spatial typesRaster storage types in an ArcSDE geodatabaseWhat is the ST_Raster storage type?XML columns in a geodatabase in SQL ServerWhat are XML schemas in ArcSDE geodatabases?Registering a third-party table containing a spatial columnData migration from one storage type to anotherMigrating geometry from one storage type to another using ArcSDE commandsMigrating raster columns using ArcSDE commandsMigrating raster columns to the ST_Raster type using the Migrate Storage geoprocessing toolFeature classes in a geodatabase in SQL ServerSubtypes in feature classes in a geodatabase in SQL ServerDomains in a geodatabase in SQL ServerFeature datasets in a geodatabase in SQL ServerTopologies in a geodatabase in SQL ServerGeometric networks in a geodatabase in SQL ServerNetwork datasets in SQL ServerParcel fabrics in a geodatabase in SQL ServerSchematic datasets in a geodatabase in SQL ServerTerrain datasets in a geodatabase in SQL ServerRelationships between datasets in a geodatabase in SQL ServerLocators in a geodatabase in SQL ServerToolboxes in geodatabases in SQL ServerRaster datasets and raster catalogs in a geodatabase in SQL ServerMosaic datasets in a geodatabase in SQL ServerVersioned tables in a geodatabase in SQL ServerReplicas in a geodatabase in SQL ServerArchives in a geodatabase in SQL ServerKeyset tables in a geodatabase in SQL ServerArcSDE log file tables in a geodatabase in SQL ServerSystem tables of a geodatabase in SQL ServerWhat is a view?A quick tour of views in the geodatabaseViews in SQL ServerExample: Creating a database view in SQL Server using SQL and registering it with ArcSDEExample: Creating a database view in SQL Server using the sdetable commandExample: Creating a spatial view in SQL Server using SQL and registering itExample: Creating a spatial view in SQL Server using the sdetable command