Comparison Predicates and Event Data
In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of...
2015-09-22
847 reads
In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of...
2015-09-22
847 reads
Predicates are a significant component within the Extended Events Engine. This article discusses one of the pieces of the puzzle of predicates - comparison operators - also known as...
2015-09-22
31 reads
At one time or another, a predicate has been the best friend or worst enemy of the data professional. If...
2015-09-21
729 reads
A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Related Posts:
Short Circuiting Your Session January 5, 2019
How To:...
2015-09-21
16 reads
In the last segment, I wrote about the data types for the payload of an event in Extended Events. In that...
2015-09-18
529 reads
Maps are like a way of overloading the data type to expose more meaningful values that relate to the payload data in question. The standard data types can also...
2015-09-18
18 reads
Today I get to talk about data types within Extended Events. This also means, I hope to be able to...
2015-09-17
642 reads
Today I get to talk about data types within Extended Events. This also means, I hope to be able to bring a little more clarity to the topic.
Related Posts:
Implicit...
2015-09-17
16 reads
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
796 reads
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
8 reads
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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