Extended Events Permissions

A common question that I am asked about Extended Events relates to what kind of permissions are required in order...

Extended Events Permissions

A common question that I am asked about Extended Events relates to what kind of permissions are required in order...

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

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

Capture Index Maintenance Operations

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

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 that is vague, we sometimes find ourselves wanting to...

Incorrect Syntax – What?

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