Extended Event Comfort
Steve wants to know if you're using Extended Events and what you think of it.
2025-02-10
128 reads
Extended Events (XE)
2022-03-02
320 reads
SQL Server Extended Events Filtering by Database Name
In this article we look at how to properly filter out events using a database name pattern in an Extended Events Session.
2021-02-08
2020-05-14
414 reads
2020-05-07
492 reads
SQL Server Checkpoint Monitoring with Extended Events
In this article Aaron Bertrand looks at how to use SQL Server Extended Events to monitor performance of checkpoints for databases not using indirect checkpoints.
2020-03-03
Performance Tuning Using Extended Events: Part 2
Part 2 of identifying performance puning opportunities using Extended Events. Learn how about shredding XML.
2019-12-23
8,148 reads
Safely Dropping Extended Event Sessions
Denis Gobo shows how you can drop an extended event session without risk of a “does not exist” error: The other day someone checked in some code and every...
2019-04-15
Extended Events Workbench
The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.
2018-10-29
2,206 reads
Converting Trace to Extended Events
A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.
2018-06-21
1,664 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers