SQL Server 2008 Advanced Database Administration: Part 1

—The Company: Veronica's Veronicas 0m 52s
—Database Schema for Veronica's Veronicas 0m 41s
—Veronica's Veronicas Locations 0m 48s

—Introduction 1m 17s
—SQL Server 2008 Editions 2m 59s
—Performing a New Installation 5m 18s
—SQL Server Installation Center 6m 45s
—Server Configuration 5m 59s
—Database Engine Configuration & Authentication 6m 15s
—Features of SQL Server 3m 32s
—Hardware, Disk Space, and Software 1m 15s
—What We Covered 1m 5s

—Introduction 2m 7s
—Indexes in SQL Server 2008 1m 50s
—Clustered and Non Clustered Indexes 5m 50s
—XML Indexes 2m 5s
—Spatial Indexes 1m 37s
—User Account Setup 9m 49s
—Creating a Clustered or Non Clustered Index 2m 0s
—Creating a Spatial Index 0m 59s
—Creating an XML Index 2m 14s
—Using T-SQL for Indexes 4m 26s
—Rebuilding and Dropping an Index 1m 33s
—Filtered Indexes 5m 13s
—Indexed Views 4m 30s
—Index Performance: Disabling Query Statistic Collection 3m 38s
—Index Performance: Fragmentation and Fill Factor 3m 49s
—Reorganizing vs. Rebuilding an Index 1m 19s
—The Database Engine Tuning Advisor 10m 38s
—What We Covered 0m 55s

—Introduction 2m 3s
—Overview of Topics 3m 57s
—Pros and Cons 2m 49s
—Full-Text Search Terminology 3m 35s
—Installing Full-Text Search 2m 59s
—Introduction to Full-Text Catalogs and Full-Text Indexes 0m 59s
—Using the Full-Text Indexing Wizard 3m 23s
—The Like Expression vs. the Contains Statement 3m 51s
—Configuring Full-Text Searches 4m 8s
—Using the Inflectional Statement 6m 48s
—Troubleshooting Full-Text Search 1m 15s
—Using Dynamic Management Views 6m 19s
—Full-Text Search Error Logs 1m 24s
—What We Covered 0m 48s

—Introduction 0m 56s
—Authentication Modes 5m 6s
—Creating Users and Logins 7m 38s
—Database-Level Roles 8m 1s
—Server-Level Roles 1m 39s
—The SA Account 5m 28s
—SQL Server Service Accounts 8m 16s
—Built-in SQL Server Accounts 1m 53s
—Securable Scopes and Schemas 6m 35s
—Schemas 3m 52s
—What We Covered 0m 52s