|
SQL Server Feature Overview
Client/Server Architecture
Relational Database
Enhancements
XML Integration of Relational
Data
Data Transformation Services
Enhancements
What's New in Analysis, Meta
Data & English Query
Installing SLQ 2000
SQL Server Editions
Pre-Installation Check list
Installed SQL Server
Components
Upgrading and Compatibility
Issues
Post-Installation Issues
Data Storage Management
Creating Databases and Logs
Planning Database Scope
Create New Databases Through
Enterprise Manager
Use Templates to Create
Databases
Script a CREATE DATABASE
Command & Use Filegroups
Detach Databases & Upgrade
Access MSDE Files
Database Options & Recovery
Models
Database Collation Options &
General Options
Manage Database Size & Delete
Databases
Importing and Exporting with DTS and Linked Servers
Data Transformation Services
Modify DTS Packages & DTS
Transformations
Full Text Searching
SQL Server 2000 Security Overview and Terminology
Authentication Options
SQL Server 2000
Authentication Modes
Giving Access to SQL Server
2000
Fixed Server and Database
Roles & Database Roles
User-Defined Roles &
Application Roles
Security and Backward
Compatibility
Backing Up and Restoring Databases
Automating Administration
Data Replication
Generate a Replication Script
Troubleshooting, Monitoring
and Optimising
Hardware Optimisation
Optimal Database Design
How to Use
what You’ve Learnt |