Contents of SQL Server DBA

It is like index in my blog to learn What a SQL Server DBA can do.

                       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