Using Profiler in SQL Server 2005 - Video Series Video Category: Monitoring and Performance Tuning SQL Server Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This series is more than an introduction; you'll get in-depth knowledge of many of the most common screens within Profiler for SQL 2005 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:

Title Skill Length Download Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens   300 12 mins. Download Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace   300 12 mins. Download Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working wit...   400 8 mins. Download Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces   400 16 mins. Download Pt. 5 - Templates and Working Within the Profiler UI   400 7 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Keyboard Shortcut for Query Analyzer: CTRL+N opens a new query window Don't forget that calls to @@ERROR and @@ROWCOUNT change after each statement. Most programmers prefer to store these global variables in a local variable immediately for later processing What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay