Reading Session Data from Memory
In the last few articles I took you through a progression of working with the event_file target from the most...
2015-10-20 (first published: 2015-10-16)
1,653 reads
SQL RNNR
Reading Session Data from Memory
In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:
How to: File Target use...
2015-10-16
6 reads
Better Practices for Reading Event_file Targets
I have demonstrated over the past couple of articles the basics involved with reading the
event_file target along with a more...
2015-10-15
631 reads
Better Practices for Reading Event_file Targets
In this article, I am going to address some better practices for Reading Event_file targets attached to an XEvent Session.
Related Posts:
How to: File Target use in Extended Events December...
2015-10-15
7 reads
Dynamically Read event_file Data
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
815 reads
Dynamically Read event_file Data
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
8 reads
Auditing Needs Reporting
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-10-13
690 reads
Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
5 reads
Intro to Reading Event_File Target Data
Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could...
2015-10-13
924 reads
Intro to Reading Event_File Target Data
The event_file target is an asynchronous consumer for Extended Events. This target stores the received payload in a proprietary binary format. Because of this, one needs to use the...
2015-10-13
43 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers