Extended Events Categories
I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left...
2015-09-09
973 reads
SQL RNNR
Extended Events Categories
Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what events contained within that package might be related to other events.
Related Posts:
How...
2015-09-09
1 reads
One Easy Strategy for the Database Enterprise
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-09-09
696 reads
One Easy Strategy for the Database Enterprise
Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Related Posts:
SQL Servers Black Box Recorder - system_health December 29, 2018
Finding Installed Event...
2015-09-09
1 reads
Learning Extended Events in 60 Days
This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The...
2015-09-08
761 reads
Learning Extended Events in 60 Days
Want to Learn Extended Events over the course of your lunch break for a couple of months? This is the Table of Contents for learning Extended Events over the...
2015-09-08
31 reads
Extended Events Objects
So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...
2015-09-15 (first published: 2015-09-08)
1,890 reads
Extended Events Objects
Today I want to start diving into some of this data a little deeper as we progress some of the of the core concepts surrounding Extended Events.
Related Posts:
Correlate SQL...
2015-09-08
2 reads
Extended Events Packages
Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects...
2015-09-07
565 reads
Extended Events Packages
The first core building block to the data that builds Extended Events is the concept around packages.
Related Posts:
Correlate Trace and XE Events December 28, 2017
SQL Servers Black Box...
2015-09-07
19 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Arc Enabled SQL Server
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Question of the Day
The Maximum Value in the Identity Column
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')
I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON
INSERT dbo.TravelLog
(
TravelLogID,
CityID,
StartDate,
EndDate
)
VALUES
(25, 5, '2025-09-12', '2025-09-17')
SET IDENTITY_INSERT dbo.TravelLog OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers