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
3 reads
Jason Brimhall
Extended Event Management Power Tools
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
4 reads
Extended Event Management Power Tools
So far in this series I have introduced a couple of tools that are suitable for helping with the management...
2015-10-06
621 reads
Backup Deployed Sessions
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
3 reads
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,231 reads
SET Operations and Metadata
Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover....
2015-10-02
664 reads
SET Operations and Metadata
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
3 reads
Session Target Metadata
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
7 reads
Session Target Metadata
With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression...
2015-10-01
737 reads
The Extended Event GUI
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,640 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers