SQL Server DBA

SQL SERVER DBA

n DBMS

n RDBMS

n Data Models

n Introduction to SQL SERVER

n History of SQL SERVER

n Software And Hardware Requirements

n IP Configuration, Domain Creation

n Client-Server Architecture

n IIS Configuration

n Installation Process

n Services, Checks after installation

n Architecture of SQL SERVER 2005

n Server startup process

n Tools in SQL SERVER 2005

1. Management Studio(SSMS)

2. BI Tools(BIDS)

3. Configuration Tools

4. Performance Tools(Profiler)

n Enabling Remote Connections

1. TCP/IP

2. Named Pipes

n Changing Port numbers

n Authentications

1. Windows Authentications

2. SQL Server Authentications

n Securities

1. Logins

2. Users

3. Roles

4. Password Management

5. Database Assignment

6. Privileges

7. Schema

n Databases

1. System Databases

2. User Databases

n Database Designing

1. Creating Database

2. Altering Database

n Files And File Groups

1. Data Files

2. Log Files

3. Primary File Group

n Memory Architecture

1. Data Pages

2. Header and Description

3. Extents

n Transactions in SQL SERVER

1. Commit

2. Rollback

3. Buffer

4. Checkpoint

n Recovery Models

1. Full

2. Bulk Logged

3. Simple

4. Non Logged Operations

n Compatibility

1. 2005

2. 2000

3. 7.0

n Backups and Planning

1. Full

2. Differential

3. Transaction Log

4. Files and File Groups

5. Temporary

6. Jobs and Schedules

7. Back up Device

8. Append and Over write

n Restorations

1. Complete restoration

2. Point in Time restoration

3. Restoration Options

n OLTP and OLAP

n Import and Export

n SSIS

1. Migrations

2. SSIS Vs DTS Packages

3. Transformations

n Up gradation

n Replication

1. Publisher

2. Publication

3. Subscriber

4. Subscription

5. Distributor

6. Agents

7. Snap Shot Publication

8. Transactional Publication

9. Merge Publication

10. Replication monitor

n Log Shipping

1. Primary Servers

2. Secondary Servers

3. Monitoring Servers

4. Jobs and Schedules

5. Blocking of Jobs

6. High Availability

n Mirroring

1. Principle Server

2. Mirror Server

3. Witness Server

4. Mirror Error

5. Stand by Server

n SQL SERVER AGENT

1. Jobs

2. Schedules

3. Alerts

4. Operators

5. Error Logs

n Database Mail

n Maintenance Plan

1. Through SSMS

2. Through SSIS

n Overview of Clustering

n Performance Tuning

n PERFMON

n SQL LITESPEED

n SQL DIAGNOSTIC MANAGER

n LOG READER

n DBCC

n SYSTEM STORED PROCEDURES

n REGULAR, WEEKLY AND MONTHLY ACTIVITIES

n TROUBLE SHOOTING

n INTERVIEW STUFF