Deployed Session Settings
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...
2015-10-05 (first published: 2015-09-28)
1,246 reads
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...
2015-10-05 (first published: 2015-09-28)
1,246 reads
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
18 reads
In the previous article in this series I shared the basics around assembling an XEvent session. The method used in...
2015-10-01 (first published: 2015-09-25)
2,660 reads
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
15 reads
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...
2015-09-24
559 reads
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
12 reads
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training,...
2015-09-23
815 reads
It is well known that there is a wealth of information within Extended Events. One can tap plenty of information about performance issues, errors, or general interest type stuff...
2015-09-23
26 reads
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,199 reads
I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...
2015-09-23
53 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