Introduction to SQL Server 2008 Administration
- 9m 14s
—Introduction
1m 7s
—What's Covered in This Course
5m 32s
—The Environment
2m 35s
Welcome to SQL Server 2008
- 14m 1s
—Introduction
2m 18s
—Solutions
5m 15s
—Data Engine
2m 59s
—Analysis and Integration Services
3m 29s
Installing SQL Server 2008
- 42m 26s
—Introduction
0m 47s
—SQL Server 2008 Editions
11m 11s
—SQL Server 2008 Requirements
1m 46s
—Downloading SQL Software
5m 52s
—SQL Server Security 101
4m 57s
—SQL Server Installation Center Overview
13m 34s
—Launching SQL Server 2008 Management Studio
3m 6s
—What We Covered & Terminology
1m 13s
Introduction to SQL Server 2008 Tools
- 34m 17s
—Introduction
2m 30s
—SQL Server Business Intelligence Development Studio Overview
3m 19s
—Analysis Services and Configuration Tools Overview
5m 39s
—Windows PowerShell 1.0 Overview
9m 32s
—SQL Server Management Studio Overview
4m 18s
—Query Interface Overview
6m 4s
—What We Covered & Terminology
2m 55s
Creating SQL Server 2008 Databases
- 58m 42s
—Introduction
2m 27s
—Database Planning
1m 41s
—Creating Databases - Overview
10m 19s
—Creating Veronica's Veronicas Database - General Page
8m 24s
—Creating Veronica's Veronicas Database - Options Page
7m 13s
—Creating a New Table
4m 4s
—Database Diagrams
2m 2s
—Creating Database Diagrams
5m 37s
—Database Views
3m 43s
—Creating a New View
7m 25s
—Creating a Synonym
1m 12s
—Recommendations
1m 3s
—What We Covered & Terminology
3m 32s
Configuring SQL Server 2008 Security
- 1h 20m
—Introduction
1m 41s
—SQL Server Security Landscape
2m 50s
—Physical Security
1m 2s
—Managing User Access
6m 36s
—Creating SQL Login and SQL User Account
7m 57s
—Testing SQL User Account
3m 5s
—Setting SQL User Permissions
9m 14s
—Server-Level Role vs. Database-Level Role
5m 34s
—Schemas Overview
18m 10s
—Protecting Your Data - Auditing SQL Server
4m 10s
—Configuring 'Surface Area'
5m 16s
—File Security and SQL Server Data Encryption
2m 5s
—SQL Server SA Login and Certificate-Based SQL Server Login
2m 37s
—Information_Schema and Sys
1m 58s
—Best Practices
3m 33s
—What We Covered and Terminology
5m 7s
Implementing Disaster Recovery
- 1h 2m
—Introduction
1m 17s
—SQL Server Recovery Models
3m 53s
—Full Recovery Model
3m 16s
—Bulk Logged Recovery Model
4m 13s
—Simple Recovery Model
0m 56s
—Backup Types
6m 8s
—Full Database Backups
6m 11s
—Restoring a Database
7m 27s
—Full File Backups
10m 56s
—Recovery Requirements
2m 53s
—Maintenance Plan Wizard
8m 12s
—Best Practices
3m 8s
—What We Covered and Terminology
3m 37s