Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,072 reads
Jason Brimhall
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
153 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2017-12-22
116 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
Despite it being new, it seems there are a handful of "facts" already published about it that may or may not be accurate. Due to that, I want to...
2017-12-22
6 reads
Capture Index Maintenance Operations
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:
Where is that Mask? December 28,...
2017-12-20
5 reads
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
620 reads
T-SQL Tuesday #097: Learning Plans
Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...
2017-12-18
473 reads
T-SQL Tuesday #097: Learning Plans
If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:
T-SQL Tuesday #102: Giving Back May 8, 2018
T-SQL...
2017-12-18
4 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
34 reads
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
332 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers