Looking at a Default Installation of SQL Server 2005 - Video Series Video Category: Installing, Deploying, and Upgrading SQL Server Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This series takes you through a standard installation of SQL Server 2005 (Developer Edition). The videos in this series show you the folders, the network libraries, the services installed and gives you the overall "Big Picture" of SQL Server.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Default SQL Server Installation   100 10 mins. Download Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New To...   200 17 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

You can use the "SQL Server Web Data Adminstrator" to manage your SQL Server from the web. Check out Microsoft's Download page and search for "SQL Server Web Data Administrator" for more Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse SQL Server 7.0 was the first time that SQL Server supported bullable BIT data types. Previous versions could only be 1 or 0