Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
   
SQL Server 2000 Training Videos
SQL Server 2000 Videos in Series Home  Subscriber Videos  

Using Profiler in SQL Server 2000 (Video Series)

Video Image Video Category: Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2000
This series is more than an introduction: you'll get in-depth knowledge of many of the most common screens within Profiler as well as Best Practices for using Profiler and creating SQL traces. This should be considered mandatory viewing by anyone wanting to become a DBA or who wants to be a serious developer.

Videos in this Series:


Miscellaneous Bits & Pieces:
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
You can use the "SQL Server 2000 Management Pack Guide" is a helpful guide to managing your SQL Server in the enterprise. Check out Microsoft's Download page and search for "SQL Server 2000 Management Pack Guide" for more
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
100% Money Back Guarantee
 
   
 
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!
 
11/20/2008 2:04:57 PM