Network Libraries, TCP/IP Ports and Configuring SQL Server for Remote Connections - Video Series Video Category: Configuration: Services, Instances, Network Utilities, Network Libraries, Port Numbers and More Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 Want to change your SQL Server's TCP/IP port? Then watch this series! This series takes an interesting look at how clients connect to SQL Server 2005 using Network Libraries. You'll learn how to manage the connections, change SQL Server's TCP port(s), how the SQL Browser Service works, and much more.

Videos in this Series:

Title Skill Length Download Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP an...   200 9 mins. Download Part 2 - SQL Server Network Library Discussion - TCP IP Connections and TCP IP P...   200 13 mins. Download Part 3 - Understanding the SQL Server Configuration Manager's Display of TCP IP ...   300 17 mins. Download Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configurati...   400 12 mins. Download Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports   500 8 mins. Download Part 6 - Using Aliases with TCP IP Connections   200 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Performance Tip: The more hard drives you spread your database across the better performance you will experience. RAID 10 offers the ultimate in performance but, for small databases, is likely to be too costly. RAID 5 for your smaller database's data files and RAID 1 for their log files will help maximize your SQL Server's performance Which of these queries will perform faster? (a) SELECT * FROM Table WHERE Salary-1000 > 10000 or (b) SELECT * FROM Table WHERE Salary > 9000. (b) will perform faster since (a) would have to calculate (Salary-1000) first and then compare that value to 10000 The TIMESTAMP data type name was replaced in Microsoft SQL Server 2000 by the ROWVERSION data type. They are the same; nothing changes but the name