SQL RNNR

Blog Post

Counting Events

After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...

2015-10-23

613 reads

Blog Post

Counting Events

This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...

2015-10-23

12 reads

Blog Post

Histograms and Events

The last few articles covered the pair_matching target and some uses and details that go along with it. For a...

2015-11-03 (first published: )

1,893 reads

Blog Post

Histograms and Events

In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...

2015-10-22

11 reads

Blog Post

Parsing Matched Events

In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...

2015-10-21

17 reads

Blog Post

Matching Events into Pairs

In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...

2015-10-20

19 reads

Blogs

The #MS_DatabaseConnector## Role: #SQLNewBlogger

By

I had seen these roles in various instances, but never dug into the new...

Asking for Help Isn’t a Weakness

By

During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...

The Proof of the Backup Is in the Pudding

By

For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...

Read the latest Blogs

Forums

The ##MS_DatabaseConnector## User

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

Planning for Change

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Planning for Change

Importing Excel files into SQL Server, Azure Edition

By Cláudio Tereso

Comments posted to this topic are about the item Importing Excel files into SQL...

Visit the forum

Question of the Day

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
GO
I then login as Demo and run this:
USE sandbox
go
SELECT CURRENT_USER
What is returned?

See possible answers