SQL Server DBA Online Training

1
(No Transcript)
2
Introduction

• Architecture
• 2005 Installation
• 2008 Installation
• 2008 Enhancements
• Configuration Settings
• System Data bases
• db Creation
• db options

3
Backups

• Recovery Models
• Backup types
• Compressed backups
• Backup options
• Backup Destination
• Backup Permissions
• Backup History
• Backup Strategies

4
Restorations

• Types of restorations
• Pre restoration options
• Restoration options
• Point in time
• Point of failure
• DR plan
• states of restoration
• Restore history
• Using third party tools- Sql light speed and
  legato networker

5
Automation

• Automating
• Automating the regular activities
• Creating the jobs
• Creating maintenance plans
• Changing the schedule
• Trouble shooting the jobs
• Viewing job history migration of jobs

6
Security

• Types of logins, authentication models
• Log in creation
• Server roles
• User Creation
• User Mapping
• Database roles
• Schemas
• User defined roles
• Principles, Permissions, Securable
• Encryption, Authentication, Authorizations
• Orphan users
• Finding fixing orphan users

7
Migration

• Launching the DBs into production
• DB refreshes
• Consolidation
• Virtualization
• Migration b/w servers different locations
• Moving to new hardware
• Steps in Migration
• Migration from other RDBMS

8
High Availability

• Log shipping
• Replication
• Replication enhancements in 2008
• DB mirroring
• Failover the databases
• Steps in Failover
• Clustering
• Types of Clusters
• Clustering enhancements in 2008

9
Performance Tuning

• Locks, Blocking Deadlocks
• Isolation Levels
• Execution plans
• Performance analysis
• Hardware counters
• Performance monitor tools
• Profiler
• DBCC commands
• DMVs
• Performance dash board 2.0
• Sql health checks
• Event viewer
• Reading error logs

10
Follow Online IT Guru

• Fb https//www.facebook.com/onlineitguruindia
• Tw https//twitter.com/onlineitguru
• G https//plus.google.com/ONLINEITGURUINDIA/abo
  ut
• YouTube https//www.youtube.com/c/ONLINEITGURUIND
  IA
• LinkedIn https//in.linkedin.com/in/onlineitgurui
  ndia