Stairway to Server-side Tracing - Level 1 - Overview of Tracing
The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.
Stairway to Server-side Tracing - Level 1 - Overview of Tracing
The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.
Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing
Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.
Stairway to Server-side Tracing - Level 2: Creating a SQL Trace Using T-SQL (Stairway Series)
This is the second article in our Stairway Series on SQL Tracing. Learn how to build traces in code with T-SQL.
Stairway to Server-side Tracing - Level 2: Creating a SQL Trace Using T-SQL (Stairway Series)
This is the second article in our Stairway Series on SQL Tracing. Learn how to build traces in code with T-SQL.
Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler
In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.
Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler
In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.
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.
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.
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.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Puri Deltamas HUB/WA 08216977749
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
BCA KCU BINTARO Hubungi.0821•3111•185
BCA KCU BINTARO Hub.0821•3111•185 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
BCA KCP Citra Towers HUB/WA ,08216977749
Citra Towers, North Tower Lt 01 No. Unit 01/GF, Jl. Benyamin Suaeb Kavling A6,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers