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,666 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
32 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
646 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
12 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
858 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
16 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
696 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
12 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
967 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
53 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers