Installing SQL Server Express Edition on Windows Vista - Video Series Video Category: Getting Started with SQL Server 2005 Express Editions Skill Level: 300 (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:

"Collation" is one of the most misunderstood terms in SQL Server. In a nutshell collation defines (a) the characters that are allowed in a column, (b) the way those characters will be sorted in the ORDER BY, and (c) how those characters will be compared (using the WHERE clause, for example) You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server Book You Should Probably Own: Michael Hernandez's "SQL Queries for Mere Mortals"