SQL Servers Black Box Recorder – system_health
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-29
352 reads
Jason Brimhall
SQL Servers Black Box Recorder – system_health
In this article, the focus will be directed to the next leg of the black box recorder - or the system_health Extended Event Session.
Related Posts:
SQLs Black Box Recorder -...
2018-12-29
20 reads
SQL Servers Black Box Recorder – Def Trace
Very much like what you may find with the airline industry, the black box recorder in SQL Server is not just a single method (device) implemented to capture all of...
2018-12-28
10 reads
SQL Servers Black Box Recorder – Def Trace
Across many professions and industries there is often a need to have some sort of device that “audits” everything that...
2018-12-28
274 reads
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of...
2018-12-27
2,947 reads
How to: File Target use in Extended Events
Using a file target is not difficult from a creation point of view (event session creation). But, some basics are critical or you could end up with fewer follicles.
Related...
2018-12-27
14 reads
Upgrading From SQL Server Profiler
How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.
As luck would have it, there is a means to correlate trace/profiler events to Extended...
2018-12-26
6 reads
Upgrading From SQL Server Profiler
I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not,...
2018-12-26
1,024 reads
Capture the Flag – The Trace Flag
Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a...
2018-12-25 (first published: 2018-12-06)
2,521 reads
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events. There...
2018-12-25
719 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers