A day in the Stream
Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...
2016-01-05
3,728 reads
SQL RNNR
A day in the Stream
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:
Quick...
2016-01-05
19 reads
Hidden GUI Gems
The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events....
2016-01-02
1,476 reads
Hidden GUI Gems
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...
2016-01-02
3 reads
Filtering Logged Data
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,225 reads
Filtering Logged Data
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
18 reads
Customize the XEvent Log Display
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,026 reads
Customize the XEvent Log Display
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
8 reads
Log Files from Different Sources
Well, it has been quite a pause between articles in the series. It is well past time to continue the...
2016-01-05 (first published: 2015-12-30)
1,819 reads
Log Files from Different Sources
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
11 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers