In-Depth Discussion of SQL Server 2000 Installation - Video Series Video Category: Installing, Deploying, and Upgrading to SQL Server 2000 Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2000 Everything from collations to network libraries, this series has all the details in the SQL Server installation program

Videos in this Series:

Title Skill Length Download Discussions on Decisions Such as What to Install, Optional Components, and Infre...   200 10 mins. Download Install SQL Server - Discussion of Collation Types and Recommendations   300 13 mins. Download Install SQL Server - Discussion of File Placement and Suggestions for High Perfo...   400 14 mins. Download Install SQL Server - Discussion of Whether Sharing SQL Server with IIS and Other...   300 9 mins. Download Install SQL Server - Discussions of Network Libraries Including Port Suggestions...   300 7 mins. Download

< Return to list of all videos

Related Links:

Microsoft Visio - Microsoft Visio can do so many things to help you diagram, plan and even reverse engineer databases that it is considered a primary tool by many network administrators, sysadmins, DBAs, data modelers, and programmers/developers. ER/Studio - For you data modelers out there Ken Henderson's "The Guru's Guide to Transact SQL" - You just can't find a better book on SQL Server. This was book could've been written in 1979 but it wouldn't matter; even when SQL Server 2010 (or whatever) comes out, it will still be relevant. A classic!

Miscellaneous Bits & Pieces:

Badly fragmented disks can decrease input/output (IO) throughput by more than 50% Keyboard Shortcut for Query Analyzer: CTRL+R hides/displays the results pane Security Tip: Be very wary of assigning logins to be members of any of the fixed server roles. The server roles in SQL Server 7.0 and 2000 have a few "holes": did you know that any member of a server role can indescriminately make other logins members of that same role? Another gotcha: the Database Creators role allows its members to drop any database!