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
50 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
955 reads
Keep an eye on those Audit files!
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
508 reads
SQL server Encryption – Transparent Data Encryption
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
572 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
439 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
751 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
615 reads
Argenis Without Borders: Fun For a Good Cause
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
525 reads
Thank You for Attending my #SQLSatOrlando Session! Slides, Resources, Recording
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...
2015-10-12
477 reads
Simplified Session Backups
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:
PowerShell to Backup XE Session...
2015-10-12
12 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers