Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

Network Libraries, TCP/IP Ports and Configuring SQL Server for Remote Connections (Video Series)

Video Image 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:


Miscellaneous Bits & Pieces:
Performance Tip: Defragmenting your SQL Server indexes is an essential management component. Most DBAs schedule their index defragmentation at least once per month and perhaps as often as once per week depending on system delta
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
Helpful Keyboard Shortcuts: "Windows key" + "F" brings up the Search window

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© 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. Refer a Friend and Get a Free Subscription!
 
1/6/2009 12:15:56 AM