Stairway to Server-side Tracing - Level 6: How to Import Trace Data
How to import a trace file into a table using T-SQL and the Profiler tool, for subsequent ad-hoc analysis.
2012-01-06
6,915 reads
Dan Guzman
- Website: https://www.dbdelta.com
Stairway to Server-side Tracing - Level 4: How to Create and View Default and black box Trace Data
An introduction to the SQL Server default and black box traces targeted at DBAs who are new to these specialized traces. The article shows how to enable and disable the default trace feature and create a black box trace. The captured events are discussed along with how to view current and historical trace data of these traces.
2011-07-13
4,305 reads
Stairway to Server-side Tracing - Level 5: How to View and Manage Running Traces
An introduction to the SQL Trace catalog views and functions used to view existing trace definitions targeted at DBAs and Developers. The article discusses T-SQL queries to view defined traces, query trace status and start/stop/delete traces.
2011-06-08
7,645 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers