Extended Events Permissions

Some view the permissions for Extended Events as a limitation. I see the required permissions as an appropriate set and recommend all to work with XE and permissions to...

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...

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...

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...

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...

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,...

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...

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...

Incorrect Syntax – What?

Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...

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...