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
3 reads
Blog Posts
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
The Trouble with Rules
I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...
2015-09-16
588 reads
T-SQL Tuesday #70 – The Enterprise
It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them...
2015-09-16 (first published: 2015-09-08)
1,308 reads
Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
713 reads
What is the Difference Between Full Load and Incremental Load
When you start working in ETL (Extract, Transform, and Load) or SSIS projects, you’ll be faced with two basic terms:...
2015-09-16 (first published: 2015-09-08)
33,930 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
7 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,436 reads
Building Better SSIS Packages Class in Dallas
I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...
2015-09-15 (first published: 2015-09-08)
1,602 reads
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...
2015-09-15
535 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers