CONTENTS
OF SQL SERVER DBA
1. Architecture.
i) SQL server Architecture
ii) Protocols
iii) Storage structure
iv) Database Architecture
2. Installation
i) Requirements
ii) 2005 Installation steps
iii) 2008 Installation Steps
iv) SQL Server 2008 enhancements
configuration settings
v) Memory settings
vi) Processor
vii) Connections
viii) Database
settings
ix) Systems Databases
x) Creating user databases
xi) Database options
3. Backups
i) Recovery Models
ii) Backup Types
iii) Backup Strategy
iv) Backup Destination
v) Backup Options
vi) Enhancements
vii) Permissions and History
4. Restoration
i) Types of Restoration
ii) Restoration options
iii) Point in restoration
iv) Recovery Process
v) Recovery options
5. Automation
i) Creating jobs
ii) Schedules
iii) Viewing job History
6. Security
i) Types of logins
ii) Authentication
iii) Creating Logins
iv) Server roles
v) DB Roles
vi) Encryption
vii) Schema
viii) Creating
New role
ix) Digital Certificate
x) Orphaned Users
7. Migration
i) Situations
ii) Steps in Migration
iii) Migrating system databases
iv) Migration to other RDBMS
8. Upgradation
i) Types
ii) Planning for Upgradation
iii) Upgrade Advisor
9. High Availability
i) Logshipping
(1) Configuring Logshipping
(2) Failover Process
ii) DB Mirroring
(1) Steps in Mirroring
(2) Types of Mirroring
(3) Configuring Mirroring
(4) Failover Steps
iii) Replication
(1) Types of Replication
(2) Configuring replication
iv) Clustering
10.
Performance
Tuning
i) Locks
ii) Isolation levels
iii) Blocking
iv) Dead locks
v) Performance Monitor
vi) Profiles
vii) Indexes
viii) DBCC
and DMV’s
