Installing SQL Server Express Edition on Windows Vista - Video Series Video Category: Getting Started with SQL Server 2005 Express Editions Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 In this 4-part video series Scott Whigham will take you through the process of installing SQL Server Advanced Series Express Edition( SSASEE)on a Windows Vista OS, as well as discuss some compponents of documentation and Management Studio ( SSMS) Highlights: Administrative Privileges in Vista Common Real World System Configuration Check Warning Messages Step by Step Feature Setup Installation Detailed Discussion of different installed version components of SSASEE Books Online Version Discussion Advanced Technique for speeding up SQL Server Management Studio

Videos in this Series:

Title Skill Length Download Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista   200 9 mins. Download Pt. 2 - Installing SQL Server 2005 Express Edition on Windows Vista   200 15 mins. Download Pt. 3 - Working with the Documentation and Books Online   200 17 mins. Download Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition   200 15 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Badly fragmented disks can decrease input/output (IO) throughput by more than 50% SQLDIAG.EXE is a handy tool that ships with your SQL Server that can provide you with detailed information about your SQL Server and its environment. Simply run SQLDIAG.EXE from the command-line Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC