Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
1 reads
Jason Brimhall
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
784 reads
Actions In Extended Events
The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some...
2015-09-15
1,429 reads
Actions In Extended Events
an action invokes memories of verbs and "to do" something. If you recall from the quick definition in the article on Extended Events Objects, an action is "a means...
2015-09-15
6 reads
Extended Events Objects
So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...
2015-09-15 (first published: 2015-09-08)
1,897 reads
Free SQL Training in Seattle
The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...
2015-09-15
671 reads
Free SQL Training in Seattle
Free Training in Seattle!
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Seattle SQL Pro Workshop 2017 Schedule October 26, 2017
T-SQL Tuesday 109: Influence Somebody Invite December 4,...
2015-09-15
3 reads
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database...
2015-09-14
527 reads
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database world, it is fairly fundamental to have some sort...
2015-09-14
15 reads
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
3 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
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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