Jason Brimhall


Blog Post

Session Action Metadata

Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant...

2015-09-30

9 reads

Blog Post

Session Event Metadata

There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...

2015-09-29

3 reads

Blog Post

Deployed Session Settings

Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...

2015-09-28

8 reads

Blog Post

The Extended Event GUI

The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:

Profiler...

2015-09-25

5 reads

Blog Post

Assembling a Session

With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:

Short...

2015-09-24

2 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

By

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

March 2026 SQL Server Security Updates

By

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

By Kunal Rathi

Comments posted to this topic are about the item How to Use sqlpackage to...

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?  

See possible answers