SQL SERVER 2005 DATABASE Introducing SQL Server 2005 What Is SQL

Document Sample
SQL SERVER 2005 DATABASE Introducing SQL Server 2005 What Is SQL Powered By Docstoc
					 SQL SERVER 2005 DATABASE

Introducing SQL Server 2005

What Is SQL Server 2005

SQL   Server   2005 Editions
SQL   Server   2005 Architecture
SQL   Server   2005 Database Objects
SQL   Server   2005 Databases
SQL   Server   2005 Database Storage
SQL   Server   Security

Installing SQL Server 2005

SQL Server Installation Planning
SQL Server Setup Application
System Configuration Checker
Installation Review

SQL Server 2005 Tools

SQL Server Management Studio 46
Log File Viewer
SQL Server Business Intelligence Development Studio
SQL Server Profiler
SQL Server Trace
Database Engine Tuning Advisor
SQL Server Configuration Manager
Reporting Services Configuration Manager

SQL Server 2005 Storage Architecture

The Resource Database
SQL Server Database Physical Structure

SQL Server 2005 Databases

System Databases
User Databases
Database Planning
Creating Databases
Database Diagrams
Views
System Views
Stored Procedure

SQL Server 2005 Security

SQL Server Authentication Modes
Principals
Permissions
SQL Server Encryption

Configuring SQL Server Network Communication

SQL Server 2005 Network Protocols
SQL Native Client Configuration
SQL Server Endpoints

Automating Administrative Tasks

Database Mail
Event Notifications
SQL Server Agent

Disaster Prevention and Recovery

Preparing the Small Works Database
Database Recovery Models
SQL Server 2005 Database Backup
SQL Server 2005 Backup Types
Backup Options
Backup Strategies
Restoring Databases
Database Snapshots

Monitoring SQL Server for Performance

Monitoring and Optimization Overview
Tools and Techniques for Monitoring Performance
Monitoring Database Modifications

SQL Server High Availability

Introduction to Availability
Failover Clustering
Log Shipping
Database Mirroring

Introduction to SQL Server 2005 Integration Services

About SSIS
Importing and Exporting Data
Transforming Data with SSIS

Introduction to Replication

Replication Overview
SQL Server Replication Agents
SQL Server Replication Types
SQL Server Replication Models
Replication Tools

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:11/14/2011
language:English
pages:2