Exposing Deployed Event Metadata with PoSH
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper...
2015-10-07
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper...
2015-10-07
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...
2015-10-06
2 reads
So far in this series I have introduced a couple of tools that are suitable for helping with the management...
2015-10-06
601 reads
Having just completed several segments on the metadata for deployed sessions, it is time to bring all of that information together and see how it can be used -...
2015-10-05
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,224 reads
Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover....
2015-10-02
659 reads
SET operations in extended events are the extra configurations that can be made to various components. As an example, a target can be configured with certain properties via the...
2015-10-02
In the case of the final core component, Targets, the exploration into the metadata can be a little awkward. At least at first. Read on to see how to...
2015-10-01
2 reads
With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression...
2015-10-01
724 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,575 reads
This one is an oldie in my blog drafts, but a goodie! So, I...
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
Let’s have devs look at their own query performance. Yes, please, sign me up...
Comments posted to this topic are about the item Using AI for the First...
Comments posted to this topic are about the item PowerBI premium capacity administration: dataset...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Basic Always On Availability Groups...
I created this trigger in SQL Server 2022:
CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GOWhere can I view "Steve logged in"? See possible answers