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  
Monitoring and Performance Tuning SQL Server - Video Category (all video categories)
Video Image This SQL Server video tutorial category is all about performance tuning your SQL Server and queries. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the "how and why" things work the way they do in SQL Server.

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
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 (4 videos) - Using Dynamic Management Views (DMVs) to Monitor Blocking an...   400 (Click for Videos) 38 mins.
Series (5 videos) - Using Profiler in SQL Server 2005   200 (Click for Videos) 55 mins.
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Com...   300 Download 21 mins.
SET Commands for Performance Tuning and Query Execution Statistics   300 Download 21 mins.
Over 2 hours of SQL Server tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "CTRL" + "ESC" displays the Start Menu
Management Tip: Automation is your friend. Make good use of SQL Server jobs and alerts to build a proactive solution. Configure alerts for common scenarios such as backup failures, log filling up, deadlocks and more. Have these alerts fire off jobs that protect and react to the situation. For example, configure an alert that fires off a log backup job if the log of database "MyDb" gets 90% full
Tips and Tricks: Microsoft's Baseline Security Analyzer (MBSA) is a great free tool for determining the attack surface area of your server
Video search
Company News
Download free videos from LearnItFirst.com
     
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/10/2008 4:43:40 PM