Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL DTS Training Videos
·
SQL Programming Videos
Create a free account
·
Sign In
SQL Server 2000 Videos in Series
Home
Subscriber Videos
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
Related Links:
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!
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
Miscellaneous Bits & Pieces:
Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.
Helpful Tools for your SQL Server: Check out Microsoft's Best Practices Analyzer Tool - a free download from microsoft.com/sql
Performance Tip: Deadlocks are the bane of SQL programmers but can often be avoided by savvy programming. One technique you can use to minimize deadlocks is to use SET DEADLOCK_PRIORITY LOW for one transaction. When a deadlock is encountered SQL Server will rollback this transaction and allow the other transaction to finish it's work
About Us
·
Corporate Philosophy
·
Advertise With Us
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SQL DTS Training Videos
·
SQL Programming Videos
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.
11/20/2008 3:05:49 PM