Installing SQL Server 2005 for the First Time (SQL Server 2005 Setup) - Video Series Video Category: Installing, Deploying, and Upgrading to SQL Server 2005 Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This is the video series for you if you are new to SQL Server 2005, even if you've had experience with prior versions of SQL Server. This is an extended series that covers every setup screen and walks you through installing SQL Server 2005 for the first time. You'l learn about how to choose the SQL Server Authentication Mode, the Network Libraries, what Collations are and how to choose the correct one for your organization and much, much more.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisite...   100 9 mins. Download Part 2 - Choosing the Right Installation For Your Organization   100 12 mins. Download Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services   200 6 mins. Download Part 4 - Choosing the Right SQL Server Authentication Mode   200 11 mins. Download Part 5 - Collations and How to Choose the Most Compatible Collation   300 9 mins. Download Part 6 - Verifying Our Installation and Reviewing The Install Logs   100 7 mins. Download Part 7 - A Look at the Installed Folders   100 15 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Want to see something cool? Run DBCC SHOWCONTIG WITH TABLERESULTS or, for more information, DBCC SHOWCONTIG with all_indexes, TABLERESULTS, all_levels Want to see what's going on in your log? Run DBCC log (<insert your database name here >) WITH TABLERESULTS What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay