Spatial DBA - Oracle and ArcSDE

[...] must be able to contact the quorum resource to become part of a SQL Server 2008 cluster. In Windows Server 2003, the entire cluster’s health and vitality depends on the quorum drive being [...]

[...] both the hardware vendor and Microsoft. ■ Leverage the Cluster Validation Tool included with Windows Server 2008 to ensure that all nodes within the cluster meet the prerequisites for deploying [...]

[...] , ALTER DATABASE, RESTORE DATABASE, Autogrowth. • Requires SQL Server 2005/2008, and Windows Server 2003/2008 (or higher version). • Instant file initialization is turned on if the SQL [...]

[...] Failover Clustering Terminology ■ SQL Server virtual server—A SQL Server virtual server is, in fact, a cluster-configured resource group that contains all resources necessary [...]

[...] that you disable the guest user in every database as a best practice for securing the database server. This recommendation does not apply to master, msdb, and tempb system databases. In order for [...]

[...] ## ##MS_PolicySigningCertificate## ##MS_PolicyTsqlExecutionLogin## Client and Database Server By definition, a client and a database server are security principals and can be secured. [...]

[...] objects. db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA db_backupoperator Granted: BACKUP DATABASE, BACKUP LOG, CHECKPOINT db_datareader Granted: SELECT db_datawriter Granted: DELETE, INSERT, [...]

[...] ANY USER, CREATE SCHEMA Granted with GRANT option: CONNECT db_backupoperator Granted: BACKUP DATABASE, BACKUP LOG, CHECKPOINT db_datareader Granted: SELECT db_datawriter Granted: DELETE, [...]

[...] SQL Server 2008 Failover Clustering Best Practices ■ Before installing SQL Server failover clustering, understand the prerequisites and verify that the clustering hardware is [...]

[...] First introduced in SQL Server 2005. SQL Server SYNONYM's can be very useful and can be created for Tables Views Assembly Stored Procedures, Table [...]

[...] Owner In SQL Server, the owner of the current database can be changed. Any user, a SQL Server login or Microsoft Windows user, who has access to connect to SQL Server can become the [...]