Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · LearnIntegrationServices.com · LearnTransactSql.com
     
Instructor-Led Video Training for SQL Server             * LearnIntegrationServices.com
* LearnTransactSql.com
* More Videobooks...
Email
Password
Register
LearnSqlServer.com LearnSqlServer.com
SQL Server 2008/2005 Videos By Category Home  Subscriber Videos  
Configuration: Services, Instances, Network Libraries, and More - Video Category (all video categories)
Video Image SQL Server administrators need to know the innermost workings of SQL Server and this set of videos teaches just that. The videos in this series will teach you about the network libraries that SQL Server uses, configuring the SQL Server system including memory and CPU settings, and even how to change SQL Server's TCP/IP ports - all of which are essential to understanding SQL Server. You'll also get great insight into the services that make up SQL Server and how things work "under the covers"

Versions/Editions Covered: SQL Server 2000 , SQL Server 2005
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (6 videos) - Network Libraries, TCP/IP Ports and Configuring SQL Server f...   400 (Click for Videos) 67 mins.
Multiple Instances - Lecture on When They're Appropriate and Special Considerati...   200 Download 18 mins.
SQL Server 2005 Services and Service Accounts - What They Do and What's New   200 Download 15 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
The two types of cluster configurations are Active/Passive and Active/Active
Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number
SQL Server 2000 Resource Kit - More Helpful Tools: USP_ShutdownDB is a script that kills all users in a database. Very useful
Video search
Company News
T-SQL Training Videos
     
Home | About Us | Advertising | Contact Us | Privacy | System Requirements | Terms and Conditions | Testimonials | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2007 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.
5/13/2008 5:33:32 PM